Mail Merge with Word and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dave - 20 Sep 2005 17:12 GMT

Okay, I'm new to this whole mail merge thing, but none the less I get to
support it. User is using Word 2003, when she brings up a document it
prompts her saying
"Opening document will run the following SQL command" it is just a select
statement ran on an excel spreadsheet. Once she clicks yes, the document
opens up excel, then the word document opens up. She goes to the name field
and does a search in field but after it searches all the records, nothing
comes up. It keeps saying record not found. Now if you do the search from
Word 2000, the name comes up just fine. Any ideas?

Reply to this Message

Doug Robbins - 20 Sep 2005 18:47 GMT

See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765 test

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Okay, I'm new to this whole mail merge thing, but none the less I get to
> support it. User is using Word 2003, when she brings up a document it
[quoted text clipped - 7 lines]
> from
> Word 2000, the name comes up just fine. Any ideas?

Reply to this Message

dave - 20 Sep 2005 20:31 GMT

Doug you are the man for the SQL error. But now for number two problem, She
goes to the name field and does a search in field but after it searches all
the records, nothing comes up. It keeps saying record not found. Now if you
do the search from Word 2000, the name comes up just fine

> See the following Knowledge Base article:
>
[quoted text clipped - 14 lines]
> > from
> > Word 2000, the name comes up just fine. Any ideas?

Reply to this Message