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
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