Personalised Mails on Lotus Notes

Posted on 2003-03-19
Medium Priority
Last Modified: 2013-12-18
I want to send personalised mails to a set of people. This list is in a spreadsheet. With two Columns: "email id" "Name"

How do I do a mail merge from Notes so that each addressee sees only their email id and addressed to that person?
Question by:ciggy1608
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

scottrma earned 100 total points
ID: 8168199
You could put all the email addresses in to the BCC field, then everybody would see the mail as addressed to themselves only.

Or you could write an agent to send the same mail to each recipient sequentially (one after another).



Assisted Solution

frenetix earned 100 total points
ID: 8168409
If you want the mail to go with a header (or maybe subject) which says "Dear John Doe:" you should program something in lotus script maybe and run it with an agent.
As I don't like lotusScript and had to conect to an SQL Db instead of an Excel spreadsheet, I did a small app in VB6 (you may use VBA or VB.NET) which composes and sends each mail (with the person's name in the header) one by one.

I think this can also be done easily with LotusScript. I don't know how to view the data from an excel spreasheet but you could easily import that data into a notes view and then acces the data from the notes view instead of your excel file.

To conect VB to notes you need to use Lotus Notes Automation Classes. Search in google: LotusScript for Visual Basic Programmers PDF. This will also help you with LotusScript.


Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question