mail merge problem

help with mail merge (word doc and excel spreadsheet). when i select the
excel spreadsheet, i get a box that has table 1, table 2, and table 3. they
are all dated the same. so i select #1. it brings up the detail on what is
in the excel spreadsheet. i just deselect the rows that i don't need but
when it do the mail merge, nothing shows up in the 'Dear " section. what
is going on?

I would guess that you have inserted a GREETINGLINE field (or the
template you are using has one - you can use Alt-F9 to find out). If so,
you may have to "match fields" or "map fields" (right-click on the
GREETINGLINE field, select Properties and see if you see a Match fields
button. This is because Word tries to identify suitable field names in
your data source for the various components of names and addresses -
e.g. firstname, lastname etc. But if it does not find names any of the
names it expects, you have to tell it which field in your data source is
the "firstname" field, and so on.

Alternatively, delete the GREETINGLINE field and insert the individual
field names that you want.

Peter Jamieson

http://tips.pjmsn.me.uk

2bmistaken4jesus wrote:
help with mail merge (word doc and excel spreadsheet). when i select the
excel spreadsheet, i get a box that has table 1, table 2, and table 3. they
are all dated the same. so i select #1. it brings up the detail on what is
in the excel spreadsheet. i just deselect the rows that i don't need but
when it do the mail merge, nothing shows up in the 'Dear " section. what
is going on?