+ Reply to Thread
Results 1 to 10 of 10

Create excel sheet which e-mails pdf out to individual

  1. #1
    Registered User
    Join Date
    09-13-2019
    Location
    England
    MS-Off Ver
    10
    Posts
    5

    Create excel sheet which e-mails pdf out to individual

    Hi,

    Really stuck on this and would appreciate any help.

    I need to create a spreadsheet that will

    a) mailmerge to a certificate template in word
    b) e-mail out that certificate to individuals via excel (in pdf format)

    If it's easier for me to complete the mail merge seperately and then run some kind of command prompt to e-mail all those certificates out that would be fine. As long as I have something set up where I can click a button and those e-mails get sent out with the neccessary attachments.

    Thank you.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,659

    Re: Create excel sheet which e-mails pdf out to individual

    .
    This is everything you need for email : https://www.rondebruin.nl/win/s1/outlook/mail.htm


    How many individuals are you going to email ? I have a few sample projects that would do what you want if you don't mind not using mail merge process but rather
    simply providing the path to each PDF you want to email.

  3. #3
    Registered User
    Join Date
    09-13-2019
    Location
    England
    MS-Off Ver
    10
    Posts
    5

    Re: Create excel sheet which e-mails pdf out to individual

    Hi,
    Firstly,thank you so much for looking at this. I will try the link tomorrow on the work laptop

    And I could be emailing between 1 to around 150 individuals depending on what courses they take.

    Would this just provide the file path or is there anyway I can get it to automatically attach the pdf to the email?

    Sorry for all the questions!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,659

    Re: Create excel sheet which e-mails pdf out to individual

    .
    The primary hurdle I can see at this point would be the PDF file name.

    Are these certificates general in nature or does each one have a different person's name on it ?

  5. #5
    Registered User
    Join Date
    09-13-2019
    Location
    England
    MS-Off Ver
    10
    Posts
    5

    Re: Create excel sheet which e-mails pdf out to individual

    Currently, the pdfs each have student names on. :/ including the date they undertook the course and the name of the course.

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,659

    Re: Create excel sheet which e-mails pdf out to individual

    .
    Not using Mail Merge ... if you were to name each PDF the same as the student email address ... and place all of the pdf's in to the same folder ....
    I can envision modifying the email code slightly so it is looking for file name that matches the recipient's email address.

    Example:

    Col A Student Name ..... Col B Student Email Address

    Billy Bob ____________ billybob@gmail.com
    John Smith __________ johnsmith@yahoo.com
    Marie MooMoo _______ mariemoomoo@uga.edu


    Basically, when you click the EMAIL button, the code will start with the first email in Col B and search for a PDF with the same name. It would
    attach that PDF certificate to the email going to Billy Bob. Then it would look for John Smit PDF and repeat the process until reaching the
    end of Col B.

    The work involved for you prior to sending the emails will be to correctly enter the email addresses in Col B.


    Or, if you wanted to enter JOHN DOE on each certificate ( *smile* ) .....

  7. #7
    Registered User
    Join Date
    09-13-2019
    Location
    England
    MS-Off Ver
    10
    Posts
    5

    Re: Create excel sheet which e-mails pdf out to individual

    At this point I wish every student was named John Doe, ha!

    Please could you attach an example of this spreadsheet so I could trial it?

  8. #8
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,659

    Re: Create excel sheet which e-mails pdf out to individual

    .
    This is probably one of the simpler ones :

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    09-13-2019
    Location
    England
    MS-Off Ver
    10
    Posts
    5

    Re: Create excel sheet which e-mails pdf out to individual

    Looking forward to trying these out tomorrow, thank you.

  10. #10
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,659

    Re: Create excel sheet which e-mails pdf out to individual

    .
    You are welcome. Let me know how it goes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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