PDF Mail Merge

Aloaha Customer statement:
I am very exited about the Aloaha PDF Suite. It allows me to use Microsoft Words Mail Merge to generate my PDF Documents which then will be emailed and/or FAXed automatically by the Aloaha PDF Suite. It was so easy to install and configure. Once the installation was ready I started the creator.exe from the installation directory and enabled save to folder, FAX Gateway, email and scripting. All I need to do now is to make sure that Mail Merge embeds the FAX and/or email Addresses in the prints and thats it. As a power user I even found out that the email and FAX commands are defined with regular expressions in the registry. In case somebody does not like the default FAX, emailto, emailfrom commands everyone can change them with a few clicks!

Aloaha PDF MailMerger Source Code

Depending on the Microsoft Office Version the Microsoft Winword MailMerge will print all documents in seperate or one print job. To get one PDF Document per Dataset one seperate print job for each Record is required.

To make MailMerging to Aloaha easier it is advised to create and use the macro below:

Sub MailMerge2Aloaha()
On Error Resume Next

Dim LastRecord
Dim LoopCounter

Application.ActivePrinter = "Wrocklage PDF Printer"
LastRecord = ActiveDocument.MailMerge.DataSource.LastRecord

For LoopCounter = 1 To LastRecord
ActiveDocument.MailMerge.DataSource.ActiveRecord = LoopCounter
With ActiveDocument.MailMerge
.Destination = wdSendToPrinter
.SuppressBlankLines = True
With .DataSource
.FirstRecord = ActiveDocument.MailMerge.DataSource.ActiveRecord
.LastRecord = ActiveDocument.MailMerge.DataSource.ActiveRecord
End With
.Execute Pause:=False
End With
Next LoopCounter

End Sub


The above mailmerge script is also available as WinWord template. Click here to download it.

You can copy the template to the WinWord startupfolder to make it always available. The autostartfolder is usually located at:
C:\Program Files\Microsoft Office\OFFICE11\STARTUP

To start the MailMerge2Aloaha please start the MailMerge2Aloaha Macro from the Tools/Macro section of your WinWord!


 MailMerge.dot (27,65 KB)

Aloaha Software / Products / Aloaha PDF Suite Pro / Tips and Tricks / Mail Merge