Solved

Word 2010 - Merge two documents?

Posted on 2013-11-07
7
372 Views
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?

Thanks,
Lily
0
Comment
Question by:mp04279
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:DrTribos
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.

HTH
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 39632237
0
 

Author Comment

by:mp04279
ID: 39639725
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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 15

Accepted Solution

by:
DrTribos earned 500 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.
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
 

Author Comment

by:mp04279
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!
Mich
0
 

Author Comment

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

Mich
0
 
LVL 15

Expert Comment

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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

786 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