Word 2010 - Merge two documents?

Posted on 2013-11-07
Medium Priority
Last Modified: 2014-01-30
I need to merge a *.txt file downloaded from our vendor ( which contains names & addressess) to an envelope template that I am creating.   The physical envelope I'm using is 8.5" x 5.5" and has a window.   The goal is to get each name/address printed on a single 8.5" x 11" piece of paper, which then the EndUser folds and places into the envelope.

Right now the EndUser copies/pastes the name/address from the text file into 'Envelopes & Labels' window that pops up and does this one at a time.   Very time consuming.   I'm hoping that we can take this *.txt file and manipulate it somehow to automerge and then print out all the single sheets.

Any suggestions?

Question by:Micheline
  • 4
  • 3
LVL 15

Expert Comment

ID: 39632234
Open the text file in MS Excel  (open Excel and browse to the text file) and put each data type into its own column.  

Save as a spreadsheet & close.

Then use mail merge from MS Word, use the spreadsheet as your data source.

LVL 15

Expert Comment

ID: 39632237

Author Comment

ID: 39639725

Thank you for your response, however I was unable to find where I would select Excel as the data source.    I am using Word 2010, Mailings, Start Mail Merge,  and when I start my mail merge, Step-by-step wizard, Step-by-step Mail Merge Wizard, Letter, NEXT, use current document (blank), NEXT, Select recipients - Use an existing list BROWSE, New Source, .....  excel is not listed as an option.  If I choose the 'Other' option, excel is still not listed.   Please advise.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 15

Accepted Solution

DrTribos earned 2000 total points
ID: 39639936
Ok... Starting with a blank canvas, these are the steps I took:
1. Open Excel
2. Enter names in Col A, with title in A1 = Name
title row is optional (I think) but keeps things tidy
3. Enter addresses in Col B, with title in B1 = Address
4. Save file to know location & close Excel

5. Open Word - blank doc
6. Select "Mailings Tab"
if you do not see this tab: right click on a blank bit of ribbon and select customise ribbon, then enable the tab
7. Click on "Select Recipients" (~4th button from left)
8. Click on "Use Existing List" (from the drop down that appears)
9. Browse to your Excel file

10. Select the 'sheet' that contains your mail merge data
11. Select OK etc...
The remaining buttons on the ribbon should now be enabled

12. Start to type your letter, e.g.
13. Select "Insert Merge Field", Name
14. Type some more
15. Select "Insert Merge Field", Address

16. Click "Preview Results"

HTH (hope this helps)


Author Comment

ID: 39822484
Hi Dr. Tribos!   Sorry for taking so long to respond... year-end duties called.    I ran as suggested and the 1st one came out GREAT!   How do I create a new page for each of the 20 addresses in the excel spreadsheet?

Much appreciated!

Author Comment

ID: 39822563
I figured it out!   Thanks so very much for your help!   Makes life so much easier!

LVL 15

Expert Comment

ID: 39822753
You are welcome,   Thanks for the grade :-)

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question