Mail Merge in Publisher 2003

[Sandy]

I have a data base in Excel 2003 that will NOT merge in Publisher. This is a
new problem since obtaining a new computer 2 weeks ago. Prior to this I was
able to use this data base in excel and merge it into Publishser. Now when I
try to Open the Data Source I get the following message: This operation
cannot be completed bcause of dialog or database engine failures. Please try
gain later.

Can anyone help? Please note the Excel file is NOT read only.

 

[JoAnn Paules [MSFT MVP]]

The first thing I'd check is whether or not you have downloaded all of the
appropriate updates for Office and Windows.

 

[Sandy]

Hi JoAnn, we have check and downloaded ALL updates, we have made sure the
file is not read only, we have made sure the colour is rgb. But still it
mail merge does not work. Can you suggest anything else I'm getting very
frustrated!

The first thing I'd check is whether or not you have downloaded all of the
appropriate updates for Office and Windows.

--

JoAnn Paules
MVP Microsoft [Publisher]

I have a data base in Excel 2003 that will NOT merge in Publisher. This is
a
new problem since obtaining a new computer 2 weeks ago. Prior to this I
was
able to use this data base in excel and merge it into Publishser. Now
when I
try to Open the Data Source I get the following message: This operation
cannot be completed bcause of dialog or database engine failures. Please
try
gain later.

Can anyone help? Please note the Excel file is NOT read only.

 

[JoAnn Paules [MSFT MVP]]

I have no idea why RGB would matter but........

You're welcome to send me the spreadsheet and I can see if the problem is
there. I wouldn't be able to get back with you until tomorrow evening tho.
If that's okay, send it to jl dot paules at gmail dot com.

--

JoAnn Paules
MVP Microsoft [Publisher]

Hi JoAnn, we have check and downloaded ALL updates, we have made sure the
file is not read only, we have made sure the colour is rgb. But still it
mail merge does not work. Can you suggest anything else I'm getting very
frustrated!

The first thing I'd check is whether or not you have downloaded all of
the
appropriate updates for Office and Windows.

--

JoAnn Paules
MVP Microsoft [Publisher]

I have a data base in Excel 2003 that will NOT merge in Publisher. This
is
a
new problem since obtaining a new computer 2 weeks ago. Prior to this
I
was
able to use this data base in excel and merge it into Publishser. Now
when I
try to Open the Data Source I get the following message: This operation
cannot be completed bcause of dialog or database engine failures.
Please
try
gain later.

Can anyone help? Please note the Excel file is NOT read only.

 

[Brian Kvalheim [MSFT MVP]]

Be sure you are running the latest MDAC:

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Install if not.

Also, try saving your Excel file as a *.csv file and see if that will merge.

--
Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com

This posting is provided "AS IS" with no warranties, and
confers no rights.