Mail merge?

Question

when doing a mail merge in Word, from Excel everything comes up in squres and lines. This was working fine the other day. Any idea as to what might have happend or how I can fix it? Please Help!!!!!!

Answer 1

I do a lot of merging with Word and Excel. Let me just run down the steps I use:

I'm assuming you have an Excel file with headings.

Open the Word document - letter, labels, catalog ...
cl Tools
cl Mailmerge

You will say yes to use the active document.
The Mailmerge Helper window opens
cl Get Data
On the top, indicate the directory/folder of the Excel file
On the bottom, click the down-arrow for files of type, and indicate that it is an Excel file.
click on the Excel file with which you wish to merge
click Open
you will want the whole spreadsheet

In the Word document, enter the field names in place

SAVE

Now, on the Mailmerge toolbar, click the Mailmerge Helper button to name any queries or sort.

Click Merge

Did it work now?