Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-29-2018, 05:35 PM
boddulus boddulus is offline Macro to send out the mails automatically Windows 8 Macro to send out the mails automatically Office 2010 32bit
Novice
Macro to send out the mails automatically
 
Join Date: Apr 2018
Posts: 2
boddulus is on a distinguished road
Default 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"
Attached Files
File Type: xlsx Tets_.xlsx (300.1 KB, 7 views)
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft