Crosswords1 min ago
Mail merging - Excel and Word
2 Answers
Does anyone know where I can download a idiots guide or view an idiots guide online showing how to mail merge in excel and word?
I need to find something that explain how you do mail merging in lay mans terms
TIA
Spaced
I need to find something that explain how you do mail merging in lay mans terms
TIA
Spaced
Answers
Best Answer
No best answer has yet been selected by spaced. 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.The help from Microsoft is usually very good.
Have you tried searching on Mail Merge in the help for Word or Excel?
If not go to the Microsoft web site and try putting Mail Merge in there. Here are some I found
http://office.microsoft.com/en-us/assistance/H A010349201033.aspx
http://office.microsoft.com/en-us/assistance/C H060832701033.aspx
http://support.microsoft.com/default.aspx?scid =%2fdefault.aspx%3fscid%3dfh%3bEN-US%3bwd2002m ail
Have you tried searching on Mail Merge in the help for Word or Excel?
If not go to the Microsoft web site and try putting Mail Merge in there. Here are some I found
http://office.microsoft.com/en-us/assistance/H A010349201033.aspx
http://office.microsoft.com/en-us/assistance/C H060832701033.aspx
http://support.microsoft.com/default.aspx?scid =%2fdefault.aspx%3fscid%3dfh%3bEN-US%3bwd2002m ail
I wrote this up for my work colleagues, it may point you in the right direction.
Mail Merge
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 !!!!!!!!
Mail Merge
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 !!!!!!!!