Simultaneous use of MS Word and Excel 2007

Asked By 10 points N/A Posted on -
qa-featured

I work for a certain non-profit organization and I have been given the task of writing a letter using MS Word 2007. This is not an ordinary letter as it will be configured to bear the names and addresses of around a thousand donors to our organization.

Since I have a spreadsheet containing all these details in Excel 2007, I am wondering if there is some way to print out a letter containing this info in Word at the same time avoiding copy pasting the details on the spreadsheet for each letter as this would take an eternity.

I am counting on your help. 

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 10 points N/A #98322

Simultaneous use of MS Word and Excel 2007

qa-featured

 

You have to use mail merge to create and print letters and other documents.Mail merge process: Set up the main document>Connect the document to a data source>Refine the list of recipients or items.>Add placeholders, called mail merge fields, to the document.>Preview and complete the merge.

1.Set up the mail merge: Please start Word>Click Start Mail Merge,from the Mailings tab, in the Start Mail Merge group>Click Letters.

2.Connect the document to a data source:Choose a data file,so again click Select Recipients,from the Mailings tab, in the Start Mail Merge group>Select Recipients.Then connect your excel file or outlook contacts.

3.Refine the list of recipients or items: Again click Edit Recipient List,from the Mailings tab, in the Start Mail Merge group and complete process.

4.Add placeholders, called mail merge fields, to the document.Map mail merge fields to your data file.Preview, complete the merge, and print the documents.On the Mailings tab, in the Finish group, click Finish & Merge, and then click Print Documents.Have a good luck.

About Morcelo Toldelo
Questions
3
Answers
115
Best Answers
24
  • Posted on -
  • Question Category:

Populating customer data within a document

Previous

Activating automatic replication on LN 6.5 server

Next

Related Questions