I have a document in Word, and a spreadsheet in Excel with the names,
addresses, etc. I need to mail merge, and I have done this plenty of times,
and my other letters with mail merge to Excel are working fine - so I don't
understand how or why I'm having this difficulty.

When I choose the data source, it gives an error message of "no visible
table." (When I do this with other letters/excel sheets, a table pops right
up onto the screen). Next, it will say "Record 1 contains too few data
fields" and there are only 2 lines on the spreadsheet it is trying to access.
There is only a letter M_ and M_1 on the info its trying to access. The
actual spreadsheet it should be accessing has 60 rows with loads of info.

I've tried to define a table in Excel, but when its time to identify a
range, I don't seem to be doing that right, so I'm stuck.

I would appreciate any help someone could give me.

Have you named the range?

Select the range and InsertNameDefine. Type in a name like MyRange.

Use that as the data source for Word mailmerge. Or just have that sheet as
first in the workbook.

For more help on Word mail merge using Excel or Access as the data source.

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 Tue, 23 Oct 2007 06:25:02 -0700, bethyb
wrote:

I have a document in Word, and a spreadsheet in Excel with the names,
addresses, etc. I need to mail merge, and I have done this plenty of times,
and my other letters with mail merge to Excel are working fine - so I don't
understand how or why I'm having this difficulty.

When I choose the data source, it gives an error message of "no visible
table." (When I do this with other letters/excel sheets, a table pops right
up onto the screen). Next, it will say "Record 1 contains too few data
fields" and there are only 2 lines on the spreadsheet it is trying to access.
There is only a letter M_ and M_1 on the info its trying to access. The
actual spreadsheet it should be accessing has 60 rows with loads of info.

I've tried to define a table in Excel, but when its time to identify a
range, I don't seem to be doing that right, so I'm stuck.

I would appreciate any help someone could give me.

This worked perfectly - thank you SO much!

"Gord Dibben" wrote:

Have you named the range?

Select the range and InsertNameDefine. Type in a name like MyRange.

Use that as the data source for Word mailmerge. Or just have that sheet as
first in the workbook.

For more help on Word mail merge using Excel or Access as the data source.

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 Tue, 23 Oct 2007 06:25:02 -0700, bethyb
wrote:

I have a document in Word, and a spreadsheet in Excel with the names,
addresses, etc. I need to mail merge, and I have done this plenty of times,
and my other letters with mail merge to Excel are working fine - so I don't
understand how or why I'm having this difficulty.

When I choose the data source, it gives an error message of "no visible
table." (When I do this with other letters/excel sheets, a table pops right
up onto the screen). Next, it will say "Record 1 contains too few data
fields" and there are only 2 lines on the spreadsheet it is trying to access.
There is only a letter M_ and M_1 on the info its trying to access. The
actual spreadsheet it should be accessing has 60 rows with loads of info.

I've tried to define a table in Excel, but when its time to identify a
range, I don't seem to be doing that right, so I'm stuck.

I would appreciate any help someone could give me.