+ Reply to Thread
Results 1 to 2 of 2

VBA CODE to automate mail merge

  1. #1
    Registered User
    Join Date
    11-16-2020
    Location
    South Africa
    MS-Off Ver
    10
    Posts
    2

    VBA CODE to automate mail merge

    Good day, I am hoping someone can help me with a code that I can input in my excel file to automatically create and send letters in PDF format?
    Our letters range from contracts, warnings, dismissals, transfers and so on... we have set templates and are currently doing it via mail merge, but I know for a fact someone here will know a way we can speed this up?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: VBA CODE to automate mail merge

    I have a program that reads things like Subject, To List, CC List, BCC List, Body, List of attachments and sends mail to them.

    https://www.excelforum.com/tips-and-...lk-mailer.html

    You should be able to send out the PDF documents by filling in the table.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Mail Merge - Create separate Mail merge pdf for each sheets of an excel file
    By sureshbvs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2021, 12:38 PM
  2. [SOLVED] Where do I find the mail merge vba code?
    By brucemc777 in forum Word Formatting & General
    Replies: 19
    Last Post: 05-25-2016, 10:25 AM
  3. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  4. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  5. Mail merge code problem...
    By jgomez in forum Word Formatting & General
    Replies: 1
    Last Post: 12-30-2010, 11:16 AM
  6. How do I input zeroes in a zip code for a mail merge?
    By db in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 09-06-2005, 05:05 PM
  7. How do I input zeroes in a zip code for a mail merge?
    By S_Suarez in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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