mail merge

[frykid50]

I am doing a mail merge from Excel 2003 to Word 2003. The Excel file has 3
worksheets, and it a protected file. When I browse to locate the file to use
for the merge, I am receive a prompt to enter the password for the file,
which then opens the excel file. However, it won't bring over the
information. I receive an error saying Unable to locate source database.
Any suggestions?

I did try to copy the data out to a new file and still received the same
error.

 

[joel]

Make sure you are calling out the correct worksheet in the workbook

 

[frykid50]

the worksheet is correct

Make sure you are calling out the correct worksheet in the workbook

 

[Gord Dibben]

In the absence of named ranges, Word will use the first worksheet in the
workbook as the source.

No other sheets will be considered.

See these sites for help.

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

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP