+ Reply to Thread
Results 1 to 4 of 4

Send Email With PDF Attachment Macro to Multiple Recipients

  1. #1
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    78

    Send Email With PDF Attachment Macro to Multiple Recipients

    Hello,

    In the attached workbook and below code, I am trying to accomplish sending an email to a bunch of different contacts with a pdf attachment.

    Can this code be changed so an email is sent to multiple recipients with an attachment for each contact? Or does someone know code that will send an email to multiple recipients with a different attachment for each? The pathways for attachments are:

    C:\Users\rhoover\Desktop\Caroline.pdf
    C:\Users\rhoover\Desktop\Dan.pdf
    C:\Users\rhoover\Desktop\Wendy.pdf
    C:\Users\rhoover\Desktop\Tina.pdf
    C:\Users\rhoover\Desktop\Ryan.pdf
    C:\Users\rhoover\Desktop\Pam.pdf
    C:\Users\rhoover\Desktop\Trent.pdf
    C:\Users\rhoover\Desktop\Dillon.pdf


    Please Login or Register  to view this content.
    Thank you for any help!!
    Last edited by Hoover5896; 04-03-2018 at 09:05 PM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Send Email With PDF Attachment Macro to Multiple Recipients

    not sure why you have 10 modules and store the code in Module 9!!! made me click thru all other 9 blank ones for no reason

    anyways it seems you only need to make a slight amendment to one line
    change this
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    if you have a different setup of attachments in your real life example (a bit more complex names or multiple attachments)
    maybe something like Ron mentions should do the trick
    https://www.rondebruin.nl/win/s1/outlook/amail6.htm

    ps Bonus tip: you dont have to manually add your signature into cell file the way you have
    https://www.rondebruin.nl/win/s1/outlook/signature.htm
    so you can have your nice Company logo in your email
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    78

    Re: Send Email With PDF Attachment Macro to Multiple Recipients

    I am sorry haha! I was experimenting and forgot to remove those lol.

    Thank you very much!

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Send Email With PDF Attachment Macro to Multiple Recipients

    not a problem
    thanks for the rep

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. [SOLVED] Email as PDF attachment for multiple recipients
    By majime01 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-17-2016, 04:16 PM
  2. How to send an email to multiple recipients from outlook with PDF.
    By marc5354 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 12-10-2015, 07:51 PM
  3. Help with Macro to email attachment to multiple recipients
    By markharris2004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2014, 08:48 AM
  4. send email to multiple recipients
    By plans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-18-2014, 09:26 AM
  5. Send workbook via email to multiple recipients
    By jdavies294 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-16-2014, 10:44 AM
  6. Macro to send email with multiple attachment
    By excelcheck123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 05:00 PM
  7. Send email to multiple recipients
    By Court16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2009, 05:20 PM

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