MS Word - Mail Merge Error

[Guest]

On Sat I was able to do a mail merge for printing labels using the list from
Excel.

Today I am getting the following each time I try to do another mail merge.

"Data Source name not found and no default driver specified.

ODBC error - [Microsoft][ODBC Driver Manager] Dat SQL: IM002
Return Code" SQL_Error"

I can not figure out what the problem is and how to correct it.

Can someone please help with this problem. I have over 2000 items to mail
out this week and need this working to make my mailing labels for the church.

Thank you,

Jeff Kerry
May email is: (e-mail address removed)

 

[Suzanne S. Barnhill]

Reconnect your mail merge main document to the data source.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Ms. Barnhill,

Can you explain how I go about reconnecting the mail merge to the data source.

Thank you,
Jeff

Reconnect your mail merge main document to the data source.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

On Sat I was able to do a mail merge for printing labels using the list from
Excel.

Today I am getting the following each time I try to do another mail merge.

"Data Source name not found and no default driver specified.

ODBC error - [Microsoft][ODBC Driver Manager] Dat SQL: IM002
Return Code" SQL_Error"

I can not figure out what the problem is and how to correct it.

Can someone please help with this problem. I have over 2000 items to mail
out this week and need this working to make my mailing labels for the church.

Thank you,

Jeff Kerry
May email is: (e-mail address removed)

 

[Suzanne S. Barnhill]

I believe Word 2000 still uses the Mail Merge Helper, and I don't remember
exactly how that works, but at some point there's a Select Data Source
button or dialog. In Word 2002/2003, with the Mail Merge Toolbar displayed,
there's an Open Data Source button that allows you to select the source.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Ms. Barnhill,

Can you explain how I go about reconnecting the mail merge to the data source.

Thank you,
Jeff

Reconnect your mail merge main document to the data source.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

On Sat I was able to do a mail merge for printing labels using the

list
from

Excel.

Today I am getting the following each time I try to do another mail merge.

"Data Source name not found and no default driver specified.

ODBC error - [Microsoft][ODBC Driver Manager] Dat SQL: IM002
Return Code" SQL_Error"

I can not figure out what the problem is and how to correct it.

Can someone please help with this problem. I have over 2000 items to mail
out this week and need this working to make my mailing labels for the church.

Thank you,

Jeff Kerry
May email is: (e-mail address removed)

 

[Guest]

Thank you for the assistance. After reading you first post I went looking
and found what you were talking about.

Jeff Kerry

I believe Word 2000 still uses the Mail Merge Helper, and I don't remember
exactly how that works, but at some point there's a Select Data Source
button or dialog. In Word 2002/2003, with the Mail Merge Toolbar displayed,
there's an Open Data Source button that allows you to select the source.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Ms. Barnhill,

Can you explain how I go about reconnecting the mail merge to the data source.

Thank you,
Jeff

Reconnect your mail merge main document to the data source.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

<Jeff> wrote in message
On Sat I was able to do a mail merge for printing labels using the list
from
Excel.

Today I am getting the following each time I try to do another mail merge.

"Data Source name not found and no default driver specified.

ODBC error - [Microsoft][ODBC Driver Manager] Dat SQL: IM002
Return Code" SQL_Error"

I can not figure out what the problem is and how to correct it.

Can someone please help with this problem. I have over 2000 items to mail
out this week and need this working to make my mailing labels for the
church.

Thank you,

Jeff Kerry
May email is: (e-mail address removed)