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.

5 comments: