Merge with Excel

[Robert Couchman]

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
([email protected])