Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access 97 - mailmerge looses formatting

Status
Not open for further replies.

neill64

Programmer
Oct 5, 2000
10
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top