+ Reply to Thread
Results 1 to 2 of 2

Use Excel Macro to run a Word mailmerge

  1. #1
    Registered User
    Join Date
    06-03-2010
    Location
    Hertfordshire, England
    MS-Off Ver
    Excel 2010
    Posts
    51

    Use Excel Macro to run a Word mailmerge

    At the moment I have a folder with 3 files:

    Setup Newsletter Labels.xls
    Membership Database.xls
    Newsletter Labels.doc

    A macro in "Setup Newsletter Labels.xls" sorts and filters data from the "Membership Database.xls" and generates a "Label Data.xls" file with selected names and address details. I have this bit working.

    At the moment I then manually open the "Newsletter Labels.doc" document in Word and run a mailmerge operation to import the data into the Word file, which contains the labels template, then I generate a "Newsletter Labels.doc" document for printing the labels to stick onto envelopes.

    I'm wondering if I can automate this whole process via the existing Excel macro?

    Also, if I move the files to a different location (or another PC) I have to re setup the "Newsletter Labels.doc" to re establish the link to the "Label Data.xls" file. I wonder if there's a way of using relative path names ( or some other approach ) so that it will always look in the current folder for the data file. I realise that this question might be better asked in a Word forum, but someone here may know the answer.

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Use Excel Macro to run a Word mailmerge

    https://www.google.com/search?q=exce...x-a&channel=sb
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

+ 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. Mailmerge from Excel and Word to new word document
    By PooH in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2011, 05:09 PM
  2. Excel - Word Mailmerge
    By OLDCell in forum Word Formatting & General
    Replies: 0
    Last Post: 06-29-2010, 10:04 AM
  3. [SOLVED] Word/Excel Mailmerge problems
    By havenlad in forum Excel General
    Replies: 3
    Last Post: 07-11-2006, 01:35 PM
  4. [SOLVED] Excel Word - Mailmerge
    By Peppermint in forum Excel General
    Replies: 1
    Last Post: 03-02-2006, 01:30 PM
  5. [SOLVED] can i use mailmerge to in excel like you would in word?
    By acain1711 in forum Excel General
    Replies: 3
    Last Post: 02-07-2006, 07:55 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