Sending the Excel file to multiple recipient in outlook application by using macro
I want to send an excel file to multiple recipient using vb. i have the recipients email id in column A . For ex
In cell A1 i have aaa@someone.com , A2 i have bbb@someone.com .... like that it goes on.. i want to send to email for available values in coumn A alone. How can i do this ... Kindly help me to solve this problem.. Thanks in advance..
See if you can adapt the code here - http://www.rondebruin.nl/mail/folder3/message.htm Example 1. Just change the B in the code to A and get rid of the If statement altogether.
Post responsibly. Search for excelforum.com
Do you need to know how pass the e-mail addresses to the code to send the mail?
or do you need the code to send your workbook via e-mail?
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks