N/APosted on - 02/23/2012
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.
Simultaneous use of MS Word and Excel 2007
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.