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 (but they are all the same). 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?

Hi,

Might be better to post this to the Word newsgroup:

http://www.microsoft.com/communities...&lang=en&cr=US

They have a whole section (actually 2) dedicated to mail merge.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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 (but they are all the same). 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?

Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 09:05:01 -0700, 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 (but they are all the same). 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?

Hi 2bmistaken4jesus,

This can happen if there are mixed data types in the column. For example, if you've got numeric data in the first few rows, the
mailmerge process might treat cells with text as being empty.

--
Cheers
macropod
[Microsoft MVP - Word]


"2bmistaken4jesus" wrote in message
...
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 (but they are all the same). 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?