Word 2010 - Merge two documents?

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?

Thanks,
Lily
MichelineSystems AdministratorAsked:
Who is Participating?
 
DrTribosCommented:
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.
Dear
13. Select "Insert Merge Field", Name
14. Type some more
15. Select "Insert Merge Field", Address

16. Click "Preview Results"

HTH (hope this helps)

Cheers,
0
 
DrTribosCommented:
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.

HTH
0
 
DrTribosCommented:
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
MichelineSystems AdministratorAuthor Commented:
Hi HTH!

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.
0
 
MichelineSystems AdministratorAuthor Commented:
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!
Mich
0
 
MichelineSystems AdministratorAuthor Commented:
I figured it out!   Thanks so very much for your help!   Makes life so much easier!

Mich
0
 
DrTribosCommented:
You are welcome,   Thanks for the grade :-)
0
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.

All Courses

From novice to tech pro — start learning today.