I was contacted recently by a reader of this site asking if there was a product or utility that would allow them to create a rich text mass mailer, complete with file attachments, and allow for Dear <FirstName> Microsoft Word-like Mail Merge functionality from data in a Lotus Notes application. As luck would have it, I had Zephyr, my Configuration-based Rich Text Mail Merge and Emailing Utility!

So I thought I would create a simple screencast showing how you can - with a simple LotusScript Agent - create a configurable Mass Mailing engine from your Lotus Notes Client Personal Address Book.

As for the LotusScript Agent to add to your Personal Address Book, here's a little something I put together (featured in the video):

Sub Initialize()
	
	Dim s As New NotesSession
	Dim db As NotesDatabase
	Dim col As NotesDocumentCollection
	Dim doc As NotesDocument
	Dim zdb As NotesDatabase
	Dim jdoc As NotesDocument
	Dim counter As Long
	
	Set db = s.Currentdatabase
	Set col = db.Unprocesseddocuments
	Set zdb = s.Getdatabase("", "zephyr.nsf", false)
	
	If Not(zdb.Isopen) Then
		MsgBox "Unable to open Zephyr!"
		Exit Sub
	End If
	
	If (col.Count = 0) Then
		MsgBox "You need to select at least one document to continue!"
		Exit Sub
	End If
	
	Set doc = col.Getfirstdocument()
	Do Until(doc Is Nothing)
		counter = counter + 1
		Print |Processing | & CStr(counter) & | of | & CStr(col.Count)
		Set jdoc = zdb.Createdocument()
		Call doc.Copyallitems(jdoc, true)
		Call jdoc.Replaceitemvalue("form", "jobdocument")
		Call jdoc.Replaceitemvalue("form_original", doc.Getitemvalue("form"))
		Call jdoc.Save(True, False, True)
		Set doc = col.Getnextdocument(doc)
	Loop
	
	Print |Push to Zephyr Complete!|
	
End Sub

With this rather simple modification, you can create feature-rich Mass Mailings with Microsoft Word-like Mail Merge via Zephyr, my totally free Configuration-based Rich Text Mail Merge and Emailing Utility!

Don't forget, you can enter to win my review copy of IBM Lotus Notes and Domino 8.5.1 from Packt Publishing by finding the easter egg found in the above demo video and posting a comment at Review: IBM Lotus Notes and Domino 8.5.1 from Packt Publishing (and Special Giveaway Contest)!