thank you sir, Its done dana done.
On Sun, Nov 28, 2010 at 11:12 AM, <in.vaib...@gmail.com> wrote: > 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 > ------------------------------ > *From: * Ankit Agrawal <ankit.agrawal...@gmail.com> > *Date: *Sat, 27 Nov 2010 08:37:47 +0530 > *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