+ Reply to Thread
Results 1 to 4 of 4

Macro to send automatically emails to different people with attachments

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    Geneva
    MS-Off Ver
    Excel 2010
    Posts
    14

    Macro to send automatically emails to different people with attachments

    Dear All,

    I'm trying to find a way to have a macro sending emails to a group of people with attachments.
    Macro forum2.xlsm

    Capture.JPG

    What I would love to have exactly is that I input the country in Column A and then the macro runs and create one email per country with the subject from Col B, and the body from Col C. Ideally it adds automatically my signature at the end which is set up in Outlook (2010).
    Then the email needs to be sent to the people in Col E to G with respect of To, Cc and Bcc. Finally it looks at the 3 attachments (potentially) linked on my computer in Col H to J.

    It's also important that the macro don't override the space/extra line in the body section and respect how I wrote it. Potentially the list of Country can be up to 20. Last but not least it would be great if it could prepare the email but not send it like this it allows me to have checks and make modifications.

    It would be amazing if one of you could help me as I spent quite some time already and I'm still far from the results I'm looking for. Please let me know if you have any questions.

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Macro to send automatically emails to different people with attachments

    This will give you the basics. I believe that to add a signature, you would need to build your body with html code instead of text (using .HTMLBody instead of .Body), and then add an html signature to it. Examples can be found on the web of how to do that.

    Please Login or Register  to view this content.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Registered User
    Join Date
    07-26-2012
    Location
    Geneva
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Macro to send automatically emails to different people with attachments

    Wow natefarm you made it looks so easy. Thanks a lot.

    Unfortunately I tried it and the macro stops when it try to attach the documents.

    If I remove this part of the code ".Attachments.Add Cells(rw, 8).Value" the it generate the emails correctly with everything correct.
    Any chance to fix this

  4. #4
    Registered User
    Join Date
    07-26-2012
    Location
    Geneva
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Macro to send automatically emails to different people with attachments

    Natefarm, please disregard my previous post.
    It works perfectly.
    Thanks a million.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to send different emails to different people with attachment
    By Dr.Tenma in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-07-2015, 08:15 AM
  2. [SOLVED] VBA to send emails with different attachments to each seperate email
    By gillyr7 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-14-2014, 02:25 PM
  3. VBA to send multiple emails with different attachments
    By gillyr7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2014, 02:33 PM
  4. Problem using a macro to send multiple emails with separate attachments
    By joshthorntonwhite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 07:31 AM
  5. [SOLVED] Need Macro that will create & send emails w/ attachments from a list in Excel
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2012, 07:02 PM

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