Mail merge and Dynamic record source

A

AbhijitDDeveloper

Hi,
First of all thanks to all. Over the last couple of months I was very much
helped by accessmonster. Thanks for all the wonderful post.
Now I have got a problem (which is why I am here) The problem is I am
transfering data from access to .csv file. And I am opening a word file after
that which has mail merge field linked to that .csv file. I want the csv file
to be saved in the %temp% folder. Which i can do in vb using Environ("Temp").
But it would be different for different user. So the .dot file which i am
creating is losing the .csv file link. It is searching the design time .csv
file path instead of searching in the corresponding %temp%. How can I do this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top