+ Reply to Thread
Results 1 to 2 of 2

Mail Merge On Steriods Using Excel

  1. #1
    Forum Contributor
    Join Date
    12-22-2004
    Location
    Kokomo, Indiana
    Posts
    236

    Question Mail Merge On Steriods Using Excel

    I would like to create a Word document which enables me to choose one of three types. The choice would come in the form of three buttons representing a particular mode of transportation. Planes, cars and motorcycles of which each is the name of a tab sheet in Excel. Within each sheet in Excel there are hundreds of characteristics with each having a unique heading name and a value associated with that name directly under the heading if it is used. For example in Row 1, column A labeled "Drive" and the cell directly below "Front". I only want to identify maybe 75 characteristics or so on any given merge. I was thinking about putting an underscore before the Field Name like "_Drive" and that would indicate I want to include that characteristic in my merge. If no underscore then no mail merge for that field name.

    On the Word document I will author the field name locations to put all the field names in their respective locations and after the merge any fields not filled would be deleted from the final document. I believe this will require some VBA programming but I'm not Word VBA smart yet. Any help would be great if this problem is possible.

    Tony

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

    Re: Mail Merge On Steriods Using Excel

    What you've described is nothing like a mailmerge. A mailmerge can use only one worksheet as a datasource and you cannot suppress mergefield output that way; doing so would cause an execution error for every such field and record. Furthermore, since you want to relocate the fields for each document, mailmerge is become an ever less relevant paradigm.

    The way a basic mailmerge works is:
    1. You design your mailmerge main document
    2. Connect the document to the relevant data source
    3. Insert mergefields where you want data for them to appear in the mailmerge main document; you don't have to use every available field and the same filed can be used multiple times.
    Additional field coding can be used to format the mergefield outputs and to conditionally display the mergefields and/or other content. For some guidance on that, see the Mailmerge Tips and Tricks thread at:
    http://www.msofficeforums.com/mail-m...ps-tricks.html
    or:
    http://windowssecrets.com/forums/sho...ips-amp-Tricks
    You can also apply filtering and/or field coding to control which records get output.
    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. [SOLVED] How I wish Excel had Mail Merge
    By ChrisEames in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-09-2015, 09:54 AM
  2. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  3. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  4. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  5. [SOLVED] Can I merge an excel list to an excel sheet like mail merge in wor
    By chcoach in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2006, 03:15 PM
  6. merge with Word How can I get excel to mail merge zip codes plus 4 correctly?
    By Kathy at Sauder Feeds in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2005, 07:05 AM
  7. [SOLVED] can you mail merge in Excel
    By Ft. Worth user in forum Excel General
    Replies: 2
    Last Post: 04-03-2005, 07: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