microsoft excel training - 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