Macro to send out the mails automatically
Hi,
I need a macro where it should
1)open an outlook application if it is not already open. if already open the it should pop up a msgbox saying "Outlook is already open" and macro should continue.
2)open a new mail item
3)It should pick the To,CC and body of the mail item fields from a particular reference cells in the excel.
4)it should copy and paste each and every row in a new mail from the attached excel sheet and send out the mail.
5) Please make sure that it copies one row in a new mail opened after the body of mail it picked up from the cell and send out a mail.
6)Excel should start picking up from data from second row in the sheet as first row is naming convection.
7) in attached sheet i could see there are 150 rows. so excel should create 150 new mail item one after other and copy each row paste it in mail item and send out the mail.
8) the subject line should be - " The data is for Cusip - here the Cusip should come for the row it has picked
For example : if it has picked first row subject line for first mail should be "The data is for Cusip - 00301W105
Same way the second mail subject should be "The data is for Cusip - 4446100
"Any help will be much appreciated " - "Thanks in advance for your help"
|