+ Reply to Thread
Results 1 to 3 of 3

Macro to email pdf attachment to different email addressees

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365 MS and mac
    Posts
    26

    Macro to email pdf attachment to different email addressees

    Hi everyone, I have a database in excel of email addresses with a corresponding path to a pdf file. Each email address has a unique file. I want to create a macro that sends a standard message to each address with the corresponding file attached.

    I use gmail as my email client but can use Outlook if I have to (I guess).

    Is this possible and can it be done in Excel or do I need to do it as a macro in Outlook? Or can it be done in Gmail?

    Any guidance would be much appreciated. If anyone has any sample code (my VBA skills are rudimentary at best!) so much the better.

    Thanks

    Rick W

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Macro to email pdf attachment to different email addressees

    If you have recipient's email in column 'A' and the file to send in column 'B' you could use this code (before to use the code open VB Editor (Alt + F11), click on menu Tool, choose References and choose 'Microsoft Outlook xx.0 Object Library'):

    Please Login or Register  to view this content.
    Regards,
    Antonio

  3. #3
    Registered User
    Join Date
    10-05-2011
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365 MS and mac
    Posts
    26

    Re: Macro to email pdf attachment to different email addressees

    Thanks very much Antonio for your response. I will try and get this to work and come back to you if any problems.

    Much appreciate your help.

    Rick

+ 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. Copy email contents to new email whilst saving attachment.
    By X82 in forum Outlook Programming / VBA / Macros
    Replies: 25
    Last Post: 08-18-2015, 03:16 PM
  2. olMail - Email Attachment Variable. Sending Email through Excel
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2014, 07:55 AM
  3. olMail - Email Attachment Variable. Sending Email through Excel
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2014, 07:41 AM
  4. Add attachment into email Macro
    By bsturds in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2014, 12:10 PM
  5. Macro to send email with attachment for each unique email Ids
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2014, 07:12 AM
  6. email excel file or worksheet as an attachment to multiple email addresses
    By jgeagle5 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2009, 03:40 PM
  7. Email Open Workbook as an Attachment to Email
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2009, 06:19 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