This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Jul 11, 2014, 1:12 AM
8 Posts

Mail Merge Excel to Lotus Notes (must download Print Merge Reporter)

  • Category: Notes Client
  • Platform: All Platforms
  • Release: 9.0.1
  • Role:
  • Tags: lotus notes,ibm notes,mail merge,excel,mass email,email blast,bulk email,mass mailing,mass mailer,email mail merge,mass email delivery,domino
  • Replies: 3

In the last year I have tried several different mail merge code posted in forums which is similar to the Word "Mail Merge to E-mail Messages" feature. I got some of them working, but for the most part they are not very user friendly, initially require Domino Developer set-up, offer insufficient mail merge logging, and a nightmare to maintain since not centrally controlled -- meaning not allowing the end user to cripple your network with an email blast festival. LOL. It would be nice to enable/disable the user's mail merge access with a single click which seems to require a 3rd party add-on...

Anyway, a 3rd party product seems to make more sense unless you plan on doing a one time "small" mail merge email blast. My customer needed to allow multiple users to send email merges to 100's of people on a monthly basis. We started using Print Merge Reporter which was user friendly and most importantly centrally controlled with nice logging. The web site is below, but since the software also has other functionality such as reporting and stuff this press release we got is easier to understand: http://www.notesmail.com/home.nsf/mailer20140311

http://www.notesmail.com/PrintMergeReporter


FYI

For those of you interested in importing Excel data into Notes here are some tips I learned over the last year while doing email merges. This will save you some headaches and hair. :) Enjoy and "stay thirsty my friends"...

INSTRUCTIONS for importing Excel data into a Notes database

1. You will first need to save the Excel spreadsheet in Lotus 1-2-3 (.WK4) format. If you are using an Excel verion earlier than 2003 SP3, then simple click File - Save As - Lotus 123 (.WK4). If you are using Excel 2003 SP3 the default security options blocks saving the spreadsheet as Lotus 1-2-3 (.WK4). You can unblock as seen below. If you are using Excel 2007 or higher it no longer supports savings as 1-2-3, so you must either (1) copy/paste the spreadsheet into another spreadsheet application (i.e. Lotus 1-2-3, Quattro Pro) to save it as Lotus 1-2-3 (.WK4) format, or (2) Save it as a CSV file, then open in another spreadsheet application to save it as Lotus 1-2-3 (.WK4) format.

Instructions to enable Excel 2003 SP3 to save as Lotus 1-2-3 WK4 format:
A. To re-enable Excel file types only, save the following file to a folder on the computer:
http://download.microsoft.com/download/2/8/B/28B644CE-9A30-4D99-AFEF-830A4FB5B839/UnblockExcel.reg
B. Double-click the file that you saved in step A.
C. Click Yes to confirm the installation of the file.
D. If an Office program is running, restart the Office program.

After you install the update, the registry settings will be updated to allow you to open and to save all file types that are supported by Microsoft Office 2003. These file types include the file types that are blocked by default in Office 2003 SP3.
(More Info: http://support.microsoft.com/kb/938810/)

2. Create a Notes view in a database that has the same number of columns as the Excel data columns. Each Notes column should have a unique field name assigned to it.

3. Open the Notes view, then click File - Import. Select the folder containing the the Lotus 123 (.WK4) you saved in step 1. Click Files of type "Lotus 1-2-3", then select the file and click Import - OK.

 

tags: mailmerge excel to notes, mail merge to email using lotus notes, mail merge excel to notes, email mail merge in lotus notes, lotus notes mail merge, mail merge to email using lotus notes, mass mailing tool for lotus notes, mail merge mass mailings, personalized mass mailer, lotus notes bulk email, mass email delivery in Domino, mass mailings - lotus, lotus notes mail merge from a microsoft excel spreadsheet


Crucial tools for IBM Lotus Notes and Domino administration and development...

Find the "crucial tools you need to succeed" including product descriptions, downloads, demos and testimonials.
Speed up IBM Lotus Notes and Domino administration and development with these crucial software tools.
Better, stronger, faster productivity for administrators and developers.
Download and try the lite (free) version

Jul 11, 2014, 2:54 PM
202 Posts
Are you sure this isn't spam?
You posted an almost identical post a couple of years ago
http://www-10.lotus.com/ldd/nd85forum.nsf/DateAllThreadedWeb/a8b70a54b18a60ae852579eb006b8829?OpenDocument

and something back in 2002

http://www-10.lotus.com/ldd/46dom.nsf/0/2eca7220bce38b0885256c880058dc33?OpenDocument


Do you have no relationship with this company apart from being their customer?


Looks like they were called out back in 2003 too http://compgroups.net/comp.lotus-notes.programmer/unfair-competition-warning-for-th/2859067
Jul 11, 2014, 4:55 PM
8 Posts
Hi Carl Tyler

No, it is not spam, and I am not related to them other than I like using their mail merge tool for the last 10 years at most of my customer sites.  I have many Lotus Notes customers and they all ask me the same thing and to be frank it's gotten quite annoying.  They want to perform mail merges to e-mail messages from Lotus Notes without using any code or programming.  They search the internet and find solutions for the most-part that requires programming.  They are non-technical users, so not coders and do not know how to use Domino Designer client which is required to create and maintain LotusScript agents. 

I re-posted it again since they can easily find it, rather than getting confused and spending much time reading how to mail merge in Lotus Notes using coding and Domino Designer.

The Notes 9 forum contains no mention of mail merging to emails at all which I found strange.  Mail merging is a basic function and it should be promoted to prevent customers from complaining of yet another reason they should migrate to a competitor messaging platform.

 

Now, as for your mention of a post from 11 years ago which is hilarious by the way... That seems like a disgruntle marketing person who doesn't like people using their competitor products. LOL.  I just researched that posting myself in terms of both the companies mentioned, and see that the WIPO (internet arbitration and mediation center) denied the complaint as false.

 

FYI

 

WIPO Arbitration and Mediation Center

ADMINISTRATIVE PANEL DECISION

Mk-Net-Work v. IVE Technologies

Case No. D2004-0302

7. Discussion and Findings

A. Identical or Confusingly Similar

Complainant states that it is the proprietor of a trademark registration. However, it has submitted a certificate of a trademark application in France. At the time of rendering its decision, the Panel checked the status of this trademark. It appears that the application is still pending. As held consistently by Panels, a trademark application is not in itself sufficient evidence of a trademark or service mark in which the Complainant has rights, since applications are often opposed or may be refused for lack of distinctiveness. The only types of right that amount to trademark rights are, in addition to registered marks, unregistered or common law trademark rights.

Pending trademark applications have been regarded as evidence that the Complainant has generated goodwill in a mark which it wishes to protect. Combined with other information about the use and renown of the alleged mark an application can be relevant to a panel finding common law trademark rights (see for example Worldblackbelt, Inc. v. Nationwide Communications, eRes Case No. AF-0881 (August 2, 2001), Bennett Coleman & Co Ltd v. Steven S. Lalwani/Bennett Coleman & Co Ltd v. Long Distance Telephone Company, WIPO Case No. D2000-0014 and The David J. Joseph Company v. Richard F. Barry, WIPO Case No. D2000-1418).

In the present case, Complainant has only provided evidence that it uses <notes-compression.com> as a domain name for a website on which information regarding its product ZipMail is provided. The website address “www.notes-compression.com” is mentioned in advertisements about ZipMail. This is not evidence that the domain name is actually used as a trademark, in order to distinguish certain goods or services, which might generate unregistered trademark rights.

This means that the Panel does not accept that the Complainant has demonstrated any unregistered rights in the trademark for which it made an application in France.

B. Rights or Legitimate Interests: Registered and Used in Bad Faith

Based on the above, the Panel concludes that Complainant did not prove that it has rights in a trademark. Given this finding, it is unnecessary for the Panel to consider whether the Respondent has any rights or legitimate interests in the domain name and whether the domain name of Respondent is registered and used in bad faith.

8. Decision

For all the foregoing reasons, the Complaint is denied.
http://www.wipo.int/amc/en/domains/decisions/html/2004/d2004-0302.html
 


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal