Dear Ankit, Thanks for your appreciation, Is your query solved. If not then what type of error is occurring.
You need to create payslips folder in C drive. And all files are stored in that folder. Pl note folder name is Payslips and not payslip. The location and name of folder can be also changed by editing cell in red colour on sheet Form which contains "C:/payslips". Please revert. Sent on my BlackBerry® from Vodafone -----Original Message----- From: Ankit Agrawal <ankit.agrawal...@gmail.com> Date: Sat, 27 Nov 2010 08:37:47 To: in.vaib...@googlemail.com<in.vaib...@gmail.com> Cc: <excel-macros@googlegroups.com> Subject: Re: $$Excel-Macros$$ Salary sending problem 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
