Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Mail Merge
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel training - Mail Merge
Resolved · Low Priority · Version Standard
Reply Thu 13 Dec 2007, 12:50Delegate Gemma said...
Gemma has attended:
Powerpoint Introduction course
Mail Merge
can you e-mail me step by step instructions on this that I can refer to
For upcoming training course dates see: Pricing & availability
RE: Mail Merge
Hi Gemma
Nice to hear from you after your course on Excel Intermediate last week.
I believe that I have read your message correctly and that you wish to learn how to mail-merge from Excel into Word.
1. In your Excel worksheet it would be best to have the fieldnames (in columns) in the first row of your worksheet.
2. Save your workbook as a normal Excel worbook.
3. Open Word, with a new document.
4. Open the Excel workbook in Word, by selecting the file type of Microsoft Excel Workbook (*.xls)
5. You can now save the data from Excel which appears in a table.
6. Close the Word document.
7. Create a new Word document, selecting Tools menu, Letters and Mailings, to continue on with creating a mail merge.
Gemma I believe you said you had version 2000 at the office. I have created these instructions using 2002.
Hope this helps
Sandy
|