Re: $$Excel-Macros$$ Salary sending problem
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.comwrote: 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.comin.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
Re: $$Excel-Macros$$ Salary sending problem
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.comwrote: 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.comin.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=wallref=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=wallref=ts
Re: $$Excel-Macros$$ Salary sending problem
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.comin.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=wallref=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=wallref=ts
Re: $$Excel-Macros$$ Salary sending problem
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.comin.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=wallref=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=wallref=ts
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.comwrote: 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.comin.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=wallref=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=wallref=ts
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=wallref=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=wallref=ts
Re: $$Excel-Macros$$ Salary sending problem
Dear Ankit, File is saved in C:/Payslip folder. 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.comin.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=wallref=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=wallref=ts
Re: $$Excel-Macros$$ Salary sending problem
HI, User want to display SAP BI Query in Excel sheet. what is the procedure, Please send the steps. On Fri, Nov 26, 2010 at 9:29 AM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Thanks Vaibhav, It was great but I discussed with my boss. He said we need salary slip in separate files so is it possible that as we click on the micro first it create a new file after it send in e-mail id(and password also be implements).because employee print out it.and accounts deptt also need the separate files for every employee in particular months. Thanks for your effort and really its mind blowing. Thanks Regards, Ankit 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-mac...@googlegroups.com *Date: *Tue, 16 Nov 2010 18:53:55 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-mac...@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=wallref=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=wallref=ts -- *Thanks Regards,* *Mohammed Abdulkaleem,* *SAP Netweaver BI-BO/EP Consultant,* *+966551836201*. -- -- 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=wallref=ts
Re: $$Excel-Macros$$ Salary sending problem
Thanks Vaibhav, It was great but I discussed with my boss. He said we need salary slip in separate files so is it possible that as we click on the micro first it create a new file after it send in e-mail id(and password also be implements).because employee print out it.and accounts deptt also need the separate files for every employee in particular months. Thanks for your effort and really its mind blowing. Thanks Regards, Ankit 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=wallref=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=wallref=ts
$$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=wallref=ts salary Slip(2).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet pay October 2010 format(2).docx Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document