Dear Ankit, For sending email through excel following is basic requirement:
If you want to send email directly without help of any application viz. Outlook, You shoud have SMTP server running on your workstation; Or else you shoul use help of Macro to send it to Outlook. At present I am not accessible to my laptop I will send you solution by this sunday. Sent on my BlackBerry® from Vodafone -----Original Message----- From: Ankit Agrawal <ankit.agrawal...@gmail.com> Sender: excel-macros@googlegroups.com Date: Mon, 22 Nov 2010 14:16:53 To: <excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Suggestion urgent Dear All, I did not get any solution from your side so it mean it does not have solution or no body knows about it. at least any body can give any suggestion on it On Tue, Nov 16, 2010 at 6:53 PM, Ankit Agrawal <ankit.agrawal...@gmail.com>wrote: > 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 -- ---------------------------------------------------------------------------------- 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
