Identify data source/query in mail merge

[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?

Thanks

Ann

 

[Cindy Meister -WordMVP-]

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