Results 1 to 17 of 17

Macro to send mails from outlook as per the email ids in excel

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Macro to send mails from outlook as per the email ids in excel

    Hi Team,

    I am trying to find codes to automate one of the manual activities that I do daily.

    I am sending a same mail from outlook to different people. The body of the mail remains the same, people in “To”, “CC”, attachment, and part of subject changes in every mail.
    I have an excel with list of projects, Email IDs of the project who should be in “To” and “CC”. So if there are 10 projects in the excel, I will have to draft 10 emails with same content in the body of the email.

    I am looking for codes by which if there are 10 projects in the excel, 10 mails are created with people in “To” and “CC” updated as per the excel and mail is saved in drafts folder. Attachments for each mail is saved in a folder in my desktop.
    Subject of the mail is “welcome to - “project name”. “Welcome to” is common in all mails but project name should be as per the excel.

    Please help me with suggestions. Sample data attached. Please help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. convert excel sheet to pdf using macro and send that pdf via email using outlook
    By suresh mongam in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-25-2015, 08:51 AM
  2. [SOLVED] Macro to send email from excel using outlook
    By Teblol in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 02-10-2015, 06:47 PM
  3. Macro to send notification from excel to my Outlook Email
    By savethisid in forum Excel General
    Replies: 18
    Last Post: 03-27-2014, 02:25 PM
  4. Excel containing macro to send bulk mails from outlook with multiple attachments
    By amandeep08 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 02:19 PM
  5. Replies: 2
    Last Post: 01-06-2010, 06:12 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1