Solved

Word 2010 - Merge two documents?

Posted on 2013-11-07
7
371 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Paste in Word 15 66
Converting large .PDF files. 6 48
Word template doing bizzare things for some users but not others 6 31
MS Word document > cursor placement 5 25
Introduction Authors who set out to write any sort of lengthy piece for online submission—be it a long question or comment on a technical form, an article, or a substantial blog entry—often find it useful to work up a draft in an editor other t…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

910 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

22 Experts available now in Live!

Get 1:1 Help Now