Sorry to interrupt, but I found I serious lapse in the macro. That is in case I am not online (server down etc), then I am not able to know to whom it was sending the mail. If it is possible to display the message body and person to whom it is sending the mail , it will be much worthy.
Regards, C.G.Kumar From: Chandra Gupt Kumar [mailto:kumar.bemlmum...@gmail.com] Sent: Saturday, August 21, 2010 12:32 PM To: 'ashish koul' Cc: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ sending e mail based on data in column in excel Dear Koul, Thanks for the help extended. But, I would like if possible, the following modification; 1. Two column for message to be sent. First for b day message and other for congratulation. 2. Whether it is possible that the macro be scheduled to run bimonthly. Regards, C.G.Kumar From: ashish koul [mailto:koul.ash...@gmail.com] Sent: Saturday, August 21, 2010 11:51 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in excel check the attachment see if it helps you Regards Ashish koul http://akoul.blogspot.com/ On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar <kumar.bemlmum...@gmail.com> wrote: Could you please share how it is possible. Regards, C.G.Kumar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Vasant Sent: Friday, August 20, 2010 1:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in excel Yes, it is possible to do Regards Vasant On 8/20/10, Chandra Gupt Kumar <kumar.bemlmum...@gmail.com> wrote: Dear All, My requirements are as follows; 1. Based on date of birth (Col D), mail to be sent on particular day to respective office for good wishes. 2. Based on date of joining , congratulation mail to be sent if the concerned completes 5,10,15,20,25,35,40 years of service. It is possible to do so ? Regards, C.G.Kumar -- ---------------------------------------------------------------------------- ------ 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards Vasant -- ---------------------------------------------------------------------------- ------ 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------- ------ 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
