#1
|
|||
|
|||
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" |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setup Outlook to ONLY SEND mails ? | ksor | Outlook | 0 | 03-14-2018 06:07 AM |
Outlook not able to send e-mails | aimforgold | Outlook | 0 | 11-01-2014 11:15 AM |
Unable to send message while receiving incoming mails | itboy | Outlook | 1 | 08-18-2014 05:38 PM |
Outlook 2010 Will Not Send E-Mails To Certain Users | J3V | Outlook | 8 | 02-20-2013 06:47 PM |
How to send mails from outlook to gmail | crks | Outlook | 1 | 01-21-2011 04:33 PM |