Jobs & Education3 mins ago
mail merge
9 Answers
can someone explain, or tell me where, in simple terms i can learn to use this. thanks
Answers
Best Answer
No best answer has yet been selected by penfold379. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Open document to be mail merged .
Click Tools � Mail Merge � Form Letter
Click Create � Active Window
Click Get Data � Open Data Source
There will be no Excel spreadsheets showing � find MS Excel Worksheet on File types - currently showing All Word Documents
Click on the file you want to merge then click open
Click OK for Entire Spreadsheet
Click Edit Main Document
Place cursor exactly where you want to start and pick the font size you want to use.
Click Insert Merge Field (top left)
Click on the field you want (all the column headings on the spreadsheet appear)� move the cursor to the next starting place � click Insert Mail Field again and select the next entry. Continue with this until all sections are completed.
Click Tools - Mail Merge � Merge
Select what you want to merge i.e. All or just part of it
Click Merge
There you are done and dusted !!!!!
Click Tools � Mail Merge � Form Letter
Click Create � Active Window
Click Get Data � Open Data Source
There will be no Excel spreadsheets showing � find MS Excel Worksheet on File types - currently showing All Word Documents
Click on the file you want to merge then click open
Click OK for Entire Spreadsheet
Click Edit Main Document
Place cursor exactly where you want to start and pick the font size you want to use.
Click Insert Merge Field (top left)
Click on the field you want (all the column headings on the spreadsheet appear)� move the cursor to the next starting place � click Insert Mail Field again and select the next entry. Continue with this until all sections are completed.
Click Tools - Mail Merge � Merge
Select what you want to merge i.e. All or just part of it
Click Merge
There you are done and dusted !!!!!
If you follow one line at a time of my instructions but substitute "Envelopes" for "Form Letter" you should be able to do it.
I've found this that may be of some help
http://www.hope.edu/resources/cit/tips/Word200 3Merge_Envelope.pdf
I've found this that may be of some help
http://www.hope.edu/resources/cit/tips/Word200 3Merge_Envelope.pdf