access 97 mailmerge

[neill64]

i have an access database located on a network server, the same database is used by about 15 people.

The database has the facility to print or save mailmerged letters using a standard letter, for this i get the database to write a text file on the local c: drive and then mailmerge from this file as i found this to be a lot quicker than running the mailmerge from the database over a network.

Variables :-

Let_path = file name of the merge letter
[Forms]![letters]![pors]= “s” for save or “p” for print
[Forms]![letters]![commondialog1].filename = save file name

Code to perform mailmerge :-

tst.Documents.Open let_path
Set tstdoc = tst.ActiveDocument
With tstdoc
If [Forms]![letters]![pors] = "s" Then
.MailMerge.Destination = wdSendToNewDocument
.MailMerge.Execute
.Application.ActiveDocument.SaveAs [Forms]![letters]![commondialog1].filename
Else
.MailMerge.Destination = wdSendToNewDocument
.MailMerge.Execute
.Application.Options.PrintBackground = False
.Application.ActiveDocument.PrintOut
End If
End With

The problem :-

everybody on the database can run the mailmerge and create letters accept for one person on one specific P.C., if she uses her P.C. the mailmerged letter losses all formatting as if in "normal" view mode. if she creates the text file and then opens the mailmerge letter and performs the merge outside of access it all works fine and if she uses another P.C. it works ok.

Somebody please help i am going insane with this problem !!!

Thanks

 

[wmichael]

Lots to do, and I do not think your code is suspect. 14 out of 15 successes means something else. Check the following;

- Have a different user do the same thing on her PC. Likely you'll see the same error occur.
- The user-specific network settings like permissions, etc. (not likely if she can do this on another PC).
- Software and service pack versions for office and OS. Make sure these match the others.
- File location settings in all office applications. See if there is something different on her PC.

Good luck! Let me know if these do not work and I can se if there are other avenues to follow.



~wmichael

"small change can often be found under seat cushions

 

[neill64]

i have checked the settings and they seem to be ok, if the user has another person logon to the p.c. they get the same problem.

Thanks for for the any help you can offer..