dominoGuru.com

Latest Updates

Loading... Please Wait!

Products & Applications

Showtime
My Blackberry Enterprise Server Push Utility for the Lotus Notes Client, allows you to create Jobs for individual Channel, Message, and Browser Content Pushes, as well as allows you to delete Pushed Channel Icons from defined recipient devices.

Time Tracker
The idea is simple. At the start of your day - upon completion of your first task - create an entry highlighting what you did and whether you feel it was an efficient or inefficient use of your time. Based on several requests, you can also select the priority, apply categories, or even align your time against a project.

For Lotus Notes Client v8.0 and above, you can use the Time Tracker Widget to make this process even easier!

Zephyr
My Configuration-based Rich Text Mail Merge and Emailing Utility, Zephyr allows you to create rich, data-driven emails to support automated workflow - all via Microsoft Word Mail Merge-like architecture. Dear <firstname> allows you to personalize each email message not only to the individual recipient, but also to the individual application workflow event!

xCopy
xCopy is a simple configurable xCopy client for the Lotus Notes client. By creating and defining xCopy Profiles, you can batch process your file backup or remote upload jobs. With the addition of the xCopy sidebar widget, you can easily kick-off these jobs, and modify both the xCopy Profiles and xCopy itself.

Community & Resources

Lotus Technical Information & Education Community

The Lotus Technical Information & Education community is comprised of IBM, business partner, and customer subject matter experts who use product wikis, published articles, white papers, community blogs and the latest in social media to build and share high quality technical content.

OpenNTF.org - Open Source Community for Lotus Notes Domino

OpenNTF is devoted to enabling groups of individuals all over the world to collaborate on IBM Lotus Notes/Domino applications and release them as open source.

developerWorks Lotus : Wikis

Share your deployment experiences and best practices in our wikis and help IBM to create scenarios for successful deployments. Contribute to the community by collaborating on shared content and leverage the shared knowledge from that community.

Mail Merge Mass Mailings in IBM Lotus Notes Domino with Zephyr

02/08/2010 12:15:00 PM by Chris Toohey

YouTube: Mail Merge Mass Mailings in IBM Lotus Notes Domino with Zephyr 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)!

 
JakeName:JakeWebsite:http://critical-masses.com/jakeofalltradesComment

Did you mean to put
Call jdoc.Replaceitemvalue("form", "jobdocument")
before
Call jdoc.Replaceitemvalue("form_original", doc.Getitemvalue("form"))?

Chris TooheyName:Chris TooheyWebsite:http://www.dominoguru.com/Comment

@Jake:

Yep!

Call jdoc.Replaceitemvalue("form", "jobdocument") sets the value of the form NotesItem in the Job Document (of course), while Call jdoc.Replaceitemvalue("form_original", doc.Getitemvalue("form")) tells me the original value of the form NotesItem.

This way, I can tell my Email Template in Zephyr to run on something like this:

form = "jobdocument" & @LowerCase(form_original) = "person"...
jakeName:jakeWebsite:http://www.critical-masses.com/jakeofalltradesComment

isn't form_original going to say "jobdocument" because you've already overwritten the form field's value? (It's a question of ordering)

jakeName:jakeWebsite:http://www.critical-masses.com/jakeofalltradesComment

whoops, I didn't see that it was a different document object. My bad.


(not published)




Evaluate this Formula: @LowerCase(@Text("FOO"))