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.

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

"frykid50" wrote:

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.

the worksheet is correct

"joel" wrote:

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

"frykid50" wrote:

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.

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/MailMe...AMailMerge.htm

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


Gord Dibben MS Excel MVP

On Wed, 8 Apr 2009 06:15:01 -0700, frykid50
wrote:

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.