Hi Vaibhav, It's really unbelievable... Even I can also use your module for my salary details. :) Thanks a ton for such type of valuable post on group.
Vaibhav, I need a small change in your macro, I always sent salary details to reporting managers and he/she forward the same to concern employee. I want to send a single mail to reporting manager. Is it possible to send a single email with 5-6 file attachments? I mean, if I mention same email id in more than one column in sheet1, macro will attach all the details in different - different excel file and sent all the files in one email. :) Thanks in advance. Regds, Manish Pansari +91 9810 88 8281 On Nov 29, 11:54 am, in.vaib...@gmail.com wrote: > Hi Again, > > I can generate in PDF for that u will require to have Office 2007, but > password protection is not possible at present. > > Is it OK. > > Sent on my BlackBerry® from Vodafone > > > > -----Original Message----- > From: Ankit Agrawal <ankit.agrawal...@gmail.com> > Date: Mon, 29 Nov 2010 11:42:43 > To: <in.vaib...@gmail.com> > > Cc: <excel-macros@googlegroups.com> > Subject: Re: $$Excel-Macros$$ Salary sending problem > > Again a recommendation, if it is transfer in to the PDF with password.can it > possible. > > Regards, > Ankit > > On Mon, Nov 29, 2010 at 11:19 AM, Ankit Agrawal > <ankit.agrawal...@gmail.com>wrote: > > > 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 athttp://www.excel-macros.blogspot.com > >>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>> 5. Excel Tips and Tricks athttp://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&...- > >>>>Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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