Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Penelope Penelope is offline
external usenet poster
 
Posts: 2
Default How can I find out what data source was used in a merge document?

How can I find the data source that was used in a mail merge document?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How can I find out what data source was used in a merge document?

If you can't open the document and it's a .doc, I don't know a way. If it's
a .docx, .docm, .htm or .rtf let us know.

If you can open the document, there are a couple of possibilities, e.g. if
you have Word 2003,

Word|Help|About|System Info...|
then wait....
then
Office 2003 Applicaitons|Microsoft Office Word 2003|Mail Merge

or start the Word VBA editor, and type the following three lines in the
Immediate Window (use ctrl-G to display it if necessary):

print activedocument.mailmerge.datasource.name
print activedocument.mailmerge.datasource.connectstring
print activedocument.mailmerge.datasource.querystring

Peter Jamieson

"Penelope" wrote in message
...
How can I find the data source that was used in a mail merge document?



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
Find out what data source the document is using? [email protected] Mailmerge 1 September 23rd 06 05:20 AM
Find out what data source the document is using? [email protected] Mailmerge 0 September 22nd 06 08:35 PM
Mail Merge can't find data source in Office XP...but it could in 2000! [email protected] Mailmerge 4 June 7th 06 03:15 PM
Word 2002 cannot find its Excel data source for mail merge harryedwards Mailmerge 5 November 23rd 05 11:09 AM
Mail Merge Error - can't find data source Aeluin Mailmerge 0 October 7th 05 12:51 AM


All times are GMT +1. The time now is 07:56 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"