Identify data source/query in mail merge  
Author Message
mf22433





PostPosted: Fri Oct 03 07:54:26 CDT 2003 Top

WordNew >> Identify data source/query in mail merge

I have a word (2000) document created from a mail merge
using data from an Access query.
I would like to include in the word document the filename
of the data source and query. Can someone please provide
the (VBA?) procedure?

Thanks

Ann

Word88  
 
 
Cindy





PostPosted: Fri Oct 03 07:54:26 CDT 2003 Top

WordNew >> Identify data source/query in mail merge Hi Ann,

> I have a word (2000) document created from a mail merge
> using data from an Access query.
> I would like to include in the word document the filename
> of the data source and query. Can someone please provide
> the (VBA?) procedure?
>
This line should return that information for a DDE-linked
Access data source

ActiveDocument.MailMerge.DataSource.Name

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)