Tuesday, September 20, 2011

COPY and PASTE as text or rich text in Lotus Notes email

Today's topic: Copy & Pasting into Lotus Notes e-mail
Copy and pasting into Lotus Notes is something we all do on regular basis (especially copying data from Excel and other MS Office products). I wanted to show a few tricks around pasting data into Lotus Notes email using Excel data as an example. Let's say you need to copy a table of data. Generally you would highlight cells in excel select COPY function and the PASTE into Lotus Notes The problem is that it's now an image that can not be edited (and/or data can not be copied from it by your recipient).
So, here are ways to convert this into a text and/or editable table:

1. Once you pasted cell/table into Lotus Notes right click on the image and select "Paste Special"
2. A Window Opens up with several options
3. Select "Text" - to paste as pure text (helpful if you need to copy/paste one cell)
4. Select "Rich Text" - to past as editable table - please note it keeps the format and colors.

Lotus Notes Email Attachments Unzip

Looking for ways to set your Lotus Notes attachments automaticaly unzip when you save them?
Here are instructions how to set it up:

1. First you need to make sure you have ZipMail for Lotus Noted set up. Its the utility that manages zipping (i.e. automaticly zips attachments and unzips attachments in Lotus Notes). If you have it installed then you just need to configure it.

2. To configure go to the Lotus Notes ini file (usually C:\Lotus\Notes\notes.ini) or just do a search for notes.ini

3. Add this line into the file (note it has to be on a separate line )
ExtMgr_Addins=MKCache,ZipMap,zmAuto

4. Restart Lotus Notes.

You should be all set. You should see UnZip checbox checked everytime you try to save an attachment.