mail merge from multiple users

[Roscoe24]

Hi
I know this is possible (e.g. opendatasource) but search as I might I can't get the exact code. Can anyone help please?

Scenario: Multiple front ends, in different folders, linked to single back end.

When mail merging, a temp table is created in FE - thereby different source for each user.

The Word doct is linked to a source (via Mail Merge) and I want to change that source according to the logon of the user, which is held on an open form.

Ideally like:
Case Mary use C:\ Db1\temptable
Case Tom use C:\Db2\temptable

I should be most grateful for any help since I have read a library full of blogs so far and got nowhere!

 

[pr2-eugin]

Can you show the code you currently have?

 

[Roscoe24]

Not really because I've not set any yet. What I've got is bits of code in my "Favourites" box - some from you, BTW! I recognised your User Name.

e.g.
<MailMergeObject>.OpenDataSource Name:="C:\MyDB.mdb", _
SQLStatement:="SELECT * FROM [MyTable]"

The users are using common letters, so in each case they need to open it , save it, then merge to the new location of the source.

 

[pr2-eugin]

Not really because I've not set any yet. What I've got is bits of code in my "Favourites" box - some from you, BTW! I recognised your User Name.

e.g.
<MailMergeObject>.OpenDataSource Name:="C:\MyDB.mdb", _
SQLStatement:="SELECT * FROM [MyTable]"

The users are using common letters, so in each case they need to open it , save it, then merge to the new location of the source.

Sorry to say, but this made no sense to me !

 

[Roscoe24]

Hi,

Having slept on the problem - again - I've decided to be a lot less clever and copy the standard letters into each user folder. From here, each time a user goes to a letter for the first time, they can reset the source to their copy of the front end table.

The downside is that it may time some hours to relink all the letters and, if the a template letter changes, it must be uploaded into each user folder - but the up-side is it won't hurt my brain to do this!

Many thanks for your time anyway. Am sending "Thanks".