Mail merge

[simon7115]

hi, i am doing a project in ACCESS for my A-Level computing project and was wondering can anyone help. i am trying to create a button which will run a mail merge so the end user can press the button to mail merge as they dont really know much about using computers? there is a way to do it as someone in my class has found it but he wont tell anyone.

would be so greatful

many thanks

simon Evans (simeopee@yahoo.com)

 

[wiffyboy]

The nearest I have got to that, is to create the merge file (usually in Word). Then in Access, use the hyperlink tool to find a file. Find the Merge file.
Now the location will be an underlined piece of txt. Right click on it (in design view) then select "change to" and then button

This will load up the merge file, then all the user has to press is the MERGE Button in WORD. Does this help?

 

[KodeKing]

Mail Merge

I recently developed this code for a client contacts db I am working on. Hope it helps!

DoCmd.TransferText acExportMerge, , "NameOfYourQuery", CurrentProject.Path & "\MailMerge\MailMerge.txt"

Dim objWord As Object
Set objWord = GetObject(CurrentProject.Path & "\MailMerge\MailMerge.doc", "Word.Document")

objWord.Application.Visible = True

objWord.MailMerge.OpenDataSource Name:=CurrentProject.Path & "\MailMerge\MailMerge.txt", LinkToSource:=True

objWord.MailMerge.Execute