+ Reply to Thread
Results 1 to 2 of 2

Mail Merge Excel Info into Multiple Different Word Documents

  1. #1
    Registered User
    Join Date
    09-28-2016
    Location
    Spokane
    MS-Off Ver
    2016
    Posts
    1

    Question Mail Merge Excel Info into Multiple Different Word Documents

    I do weekly surveys of HOA properties in developments. I use a lap top which contains all of homeowner contact info, while I drive I inspect for a handful of infractions and enter the infraction type to the corresponding homeowner. Currently I open one word document for each specific infraction type as all of them need a slightly different letter. Starting with infraction 'A', I merge the contact and infraction info into a word doc just for that infraction then, save, print, & close... then repeat that for infraction 'B', 'C', 'D', 'E' etc... It's pretty time consuming as each development also needs different varieties of these letters... Is there a way to make excel choose the specific infraction word document to merge into, so that I can run all of the letter varieties at once?

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,531

    Re: Mail Merge Excel Info into Multiple Different Word Documents

    That kind of thing can be done with field coding, using a single mailmerge main document. For an elaborate demonstration, see my last post and the one before it in: http://www.eileenslounge.com/viewtopic.php?f=26&t=12802
    Last edited by macropod; 09-29-2016 at 12:33 AM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. Excel/Word Mail Merge, saving as individual documents using two mergefields as name
    By flakjack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2016, 12:34 PM
  2. Replies: 0
    Last Post: 09-11-2015, 09:11 AM
  3. Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
    By pl05.lau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  4. [SOLVED] Macro for mail merge and save as word documents
    By aganesan99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2013, 09:16 AM
  5. Mail merge with multiple lines of data in excel to feed one Word doc
    By gaucher2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 02:57 PM
  6. Replies: 2
    Last Post: 11-09-2007, 07:54 AM
  7. how do I use mail merge in excel for word documents
    By Lisa J Duffy in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 09: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