Identify data source/query in mail merge

  • Thread starter Thread starter Ann
  • Start date Start date
A

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
 
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
:-)
 
Back
Top