Hello all,
not used this room before but my excel project has growen
into ms word.
please can someone help,
i need to be able to mailmerge with word, YES i can
already do this....
BUT....!!!
if my program moves (e.g. excel spreadsheet and word
documents)
i need the mailmerge to always look for its data in the
activedocument.Path
i know i can use this in VB code when using a querystring,
BUT is there any way of doing this with the merge option??
will it be using VB???
thank you,
Robert Couchman
(robert.couchman@jobcentreplus.gsi.gov.uk)
Peter Jamieson - 10 Mar 2004 07:46 GMT
I think you will have to use VB(A) to reconnect to the datasource to be
sure - generally speaking Word uses an absolute pathname. It /may/ connect
to the file in the same directory in some circumstances but I wouldn't want
to rely on it.
As a rule if you are moving things around you should turn your mail merge
main document back into a "Normal" Word document before moving it. If you
don't, users will almost certainly see the "Cannot find data source"
message. The document should retain its field codes, but it will lose
a. the connection tot the data source
b. the mail merge type (Form Letters, Catalog/Directory etc.)
c. the mail merge destination
d. filter and sort options
So in other words any VB(A) you use will need to restore all those things.

Signature
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/
> Hello all,
>
[quoted text clipped - 22 lines]
> Robert Couchman
> (robert.couchman@jobcentreplus.gsi.gov.uk)