+ Reply to Thread
Results 1 to 2 of 2

Vba to mail merge data in excel into word and attach it as an email attachment in pdf form

  1. #1
    Registered User
    Join Date
    11-22-2014
    Location
    Kenya
    MS-Off Ver
    2007
    Posts
    6

    Vba to mail merge data in excel into word and attach it as an email attachment in pdf form

    Hello Friends,

    I have some data in excel, I am doing a mail merge. The data is in columns A:G. Column G has the email addresses and would like to send each mail merged letter to that email address.
    The letters should be mail merged in to individual work documents and saved as pdf then send to the respective email addresses. Kindly assist.

  2. #2
    Registered User
    Join Date
    02-20-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Vba to mail merge data in excel into word and attach it as an email attachment in pdf

    Think Ron DeBruin's website has something that might help - check it out...

    http://www.rondebruin.nl/win/section1.htm

+ 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. code to attach the draft mail in new compose mail as attachment in outlook 2010
    By priya1987 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:38 AM
  2. 2 Excel Sprdshts 1-word mail merge, 1 for data
    By sammar12 in forum Excel General
    Replies: 0
    Last Post: 04-24-2007, 10:27 AM
  3. [SOLVED] How do I attach an excel document to a word one for mail merge?
    By Ruth in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 06:35 PM
  4. [SOLVED] How can I get Excel filtered data into a word mail merge using a m
    By REVA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2006, 04:25 PM
  5. [SOLVED] Word mail merge with Excel data
    By Bailey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2005, 06:06 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