Solved

Word 2010 - Merge two documents?

Posted on 2013-11-07
7
369 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 14

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 14

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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 14

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 14

Expert Comment

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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now