+ Reply to Thread
Results 1 to 5 of 5

Macro to: Send different PDF files to different receipient

  1. #1
    Registered User
    Join Date
    09-09-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    35

    Question Macro to: Send different PDF files to different receipient

    Hi All,

    I'm looking for a way to be able to :

    1) Send different PDF files to different receipients i.e. PDF1 is meant for email1, PDF2 for email 2...etc
    2) Include a generic message with each mail

    Is there a way to do this?

    Regards,

    reach

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Macro to: Send different PDF files to different receipient

    Hi reach,

    check and adapt from here..

    http://stackoverflow.com/questions/1...ith-attachment
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    09-09-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Macro to: Send different PDF files to different receipient

    Thanks. I'm a newbie VBA user and have been doing some VBA only in excel. I'm not familiar with some of the stuff being used in the link. Could I get someone to explain what it does? Do I need to enable all the codes that are commented out?

  4. #4
    Registered User
    Join Date
    09-09-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Macro to: Send different PDF files to different receipient

    Can't get it to work... Anyone have any idea how it works? here's the macro:

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Macro to: Send different PDF files to different receipient

    or
    Please Login or Register  to view this content.
    let's say in Sheet1, column A - the name, column B - email address, column C - the file name as :C:\users\Sam\desktop\help.xls, column D - another file, column E - subject.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ 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 data from one file to multiple other existing files
    By masben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 05:21 AM
  2. [SOLVED] Send customized emails to receipient with attaching a .ppt or .doc file
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2012, 01:04 PM
  3. Excel 2003 Routing Receipient With Windows 7
    By sgit in forum Excel General
    Replies: 0
    Last Post: 11-03-2010, 01:10 AM
  4. Replies: 0
    Last Post: 01-19-2006, 10:45 AM
  5. question "File -> Send To -> Mail Receipient"
    By cat bit @somewhere in forum Excel General
    Replies: 0
    Last Post: 10-31-2005, 01:05 AM

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