Reply
 
Thread Tools Display Modes
  #1   Report Post  
dave
 
Posts: n/a
Default Mail Merge with Word and Excel

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?
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

--
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
"dave" wrote in message
news
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?



  #3   Report Post  
dave
 
Posts: n/a
Default

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

"Doug Robbins" wrote:

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

--
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
"dave" wrote in message
news
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
Mail Merge of a Date from Excel Data into Microsoft Word Keith A Microsoft Word Help 2 August 31st 05 05:01 AM
Word Mail Merge using Excel data HT New Users 3 July 14th 05 12:28 PM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


All times are GMT +1. The time now is 12:03 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"