+ Reply to Thread
Results 1 to 2 of 2

Merge address in XL to Word letter template

  1. #1
    Registered User
    Join Date
    01-23-2005
    Posts
    20

    Merge address in XL to Word letter template

    Friends,
    Here is the basic situation. I have about 10 excel sheets containing addresses of thousands of contacts. They are written like this:
    [Prior Title][First Name][Middle Name][Last Name][End Title][Street Address Line 1][Street Address Line 2][Street Address Line 3][City, State Zip]

    Not all cells, like titles, contain data for all persons. Anyway, what I need is a way to insert, automatically, these addresses into the proper address space in a prewritten letter and on an envelope. I know how to merge to create address labels in word, but not merge them into a completed letter, as in:

    Word File:
    ===
    December 7, 2005

    [Prior Title][First Name][Middle Name][Last Name][End Title]
    [Street Address Line 1]
    [Street Address Line 2]
    [Street Address Line 3]
    [City, State Zip]

    Dear [Prior Title][First Name][Last Name][End Title]

    How are you, blah, blah, important stuff, blah.

    Sincerely,

    TheOne
    ============

    So, one letter, thousands of different addresses. What do you folks think I can do to achieve this? Any suggestions, except for how to make normal address labels, would be greatly appreciated.

    Thanks,
    TheOne

  2. #2
    Registered User
    Join Date
    03-08-2005
    Location
    The Netherlands
    Posts
    25

    Arrow Merge Excel in Word

    Hi TheOne,

    It works principally the same way as with the labels, create a new document, under Tools you a menu option that leads you to the creation of merged documents.

    You have to choose the document and the source file and then you can add the fields as you wish,

    You can open the ready-made letter and past it and you have your letter, you will have to select the next source file untill you have run the 10 of then condition to simplify it all is that all the column headers are identical in all the 10 excel sheets.

    I cant give you the exact menu options names since I use a Dutch version and the menu names are different.

    Good luck

    Hans
    Hans

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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