Namste Vaibhav ji, *Unbelievable task. *how I tell you what you are? but sir after clicking it, it add sheet and creating the file as well. but not saving it and occurring a error. so please implement it also.
Thanks & Regards Ankit ~~~~ On Fri, Nov 26, 2010 at 8:37 PM, in.vaib...@googlemail.com < in.vaib...@gmail.com> wrote: > Dear Ankit, > > Check the attached file. It meets all requirements. > > Create folders name "payslip" in C: > > //BR > > VaibhavJ > > Life is cool... > > > On Thu, Nov 25, 2010 at 11:05 PM, <in.vaib...@gmail.com> wrote: > >> Dear Ankit, >> >> I have made one macro this will send payslip as in-line to email. >> >> Follow the instruction sheet. If format and everything is OK then I will >> work for your other requirement. >> >> Pl note that I will able to generate password protected XLS file. >> >> Please revert for help. >> >> Sent on my BlackBerry® from Vodafone >> ------------------------------ >> *From: * Ankit Agrawal <ankit.agrawal...@gmail.com> >> *Sender: * excel-macros@googlegroups.com >> *Date: *Tue, 16 Nov 2010 18:53:55 +0530 >> *To: *<excel-macros@googlegroups.com> >> *ReplyTo: * excel-macros@googlegroups.com >> *Subject: *$$Excel-Macros$$ Salary sending problem >> >> Hello Sir, >> >> I have a problem related to mail through excel. basically I have to make >> salary slip. and forward it to the employees. I manage the data into the >> excel and use mail merge in MS word. now the problem is, I have to make >> separate file for each employee and have to send one by one on their e-mail >> id. >> >> Question >> >> 1- Is any way that we can make separately file automatically and send to >> it mail automatically to each employee. >> 2- is any way that every file having its own password and its password >> would be employee DOB or their PAN may be any other key >> >> Here I am sending you sample file so please illustrate it because I am >> new in the excel and don't know much more about other computer software & >> tools >> >> >> Thanks & regards >> Ankit >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts