Mail Merge relative reference to data source

Hi

I've been trying to find out over the last few days how exactly create/
fake a relative reference (as opposed to an absolute eg C:\blah\blah
\blah) to an Excel spread*** I'm using as a data source. It sounds
possible from some things I've read online, and I think I understand
the theory but unfortunately I'm not proficient in VBA to do it, and
nobody has posted the code anywhere (and as this is the only vb I'll
be touching it's not worth learning the whole caboodle).

It sounds like you have to create an AutoOpen macro (that kicks in on
opening the doc) that changes the path of the MailMerge datasource to
a combination of the file path of the word document and the file name
chosen for the spread***. I cobbled together some code that looked
ok, and it seemed to work... but only once. on moving the duplicate
folder it reverted to referring to the original again.

I'm sure the code must be simple but I'm not having any luck

would appreciate some help. typically the project somewhat relies on
me finding a fix for this and will be seriously hampered without one!

thanks in advance

Chris

.

Loading