How to create/embed table or existing Excel spreadsheet into Lotus Notes 6.5 email
I have been successful in creating and sending an email through Lotus
Notes. However, I need to be able to format the body so that the message is more presentable. Currently, I filter a spreadsheet based on two named ranges and send an email to the SOX audit team member and copy the SOX control owner. I copy the values from selected columns on the visible rows and separate those values by tabs. However, the presentation is bad as the data is variable in length and therefore the alignment is not correct. I would like to learn how to create/embed either a table into the Lotus Notes email body or embed an Excel spreadsheet into the Lotus Notes email body. Any help would be greatly appreciated! Keith |
How to create/embed table or existing Excel spreadsheet into Lotus Notes 6.5 email
Hi BooBoo
Look on this site for information Sending mail from Lotus Notes (XL-Dennis) http://www.excelkb.com/?cNode=1X5M7A -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BooBoo" wrote in message oups.com... I have been successful in creating and sending an email through Lotus Notes. However, I need to be able to format the body so that the message is more presentable. Currently, I filter a spreadsheet based on two named ranges and send an email to the SOX audit team member and copy the SOX control owner. I copy the values from selected columns on the visible rows and separate those values by tabs. However, the presentation is bad as the data is variable in length and therefore the alignment is not correct. I would like to learn how to create/embed either a table into the Lotus Notes email body or embed an Excel spreadsheet into the Lotus Notes email body. Any help would be greatly appreciated! Keith |
How to create/embed table or existing Excel spreadsheet into Lotus Notes 6.5 email
On Feb 15, 10:04 am, "Ron de Bruin" wrote:
Hi BooBoo Look on this site for information Sending mail from Lotus Notes (XL-Dennis)http://www.excelkb.com/?cNode=1X5M7A -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "BooBoo" wrote in ooglegroups.com... I have been successful in creating and sending an email through Lotus Notes. However, I need to be able to format the body so that the message is more presentable. Currently, I filter a spreadsheet based on two named ranges and send an email to the SOX audit team member and copy the SOX control owner. I copy the values from selected columns on the visible rows and separate those values by tabs. However, the presentation is bad as the data is variable in length and therefore the alignment is not correct. I would like to learn how to create/embed either a table into the Lotus Notes email body or embed an Excel spreadsheet into the Lotus Notes email body. Any help would be greatly appreciated! Keith- Hide quoted text - - Show quoted text - Excellent article, however, this creates a picture of the worksheet. I actually want to either create a Lotus Notes embedded table or embed the worksheet as an object in the email body. In this manner, the user can manipulate the worksheet. Thanks for that site! It is a really great site and I will be using it in the future! |
How to create/embed table or existing Excel spreadsheet into Lotus Notes 6.5 email
Sorry, I never used Notes.
Can you use html in notes ? See this Outlook example http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BooBoo" wrote in message oups.com... On Feb 15, 10:04 am, "Ron de Bruin" wrote: Hi BooBoo Look on this site for information Sending mail from Lotus Notes (XL-Dennis)http://www.excelkb.com/?cNode=1X5M7A -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "BooBoo" wrote in ooglegroups.com... I have been successful in creating and sending an email through Lotus Notes. However, I need to be able to format the body so that the message is more presentable. Currently, I filter a spreadsheet based on two named ranges and send an email to the SOX audit team member and copy the SOX control owner. I copy the values from selected columns on the visible rows and separate those values by tabs. However, the presentation is bad as the data is variable in length and therefore the alignment is not correct. I would like to learn how to create/embed either a table into the Lotus Notes email body or embed an Excel spreadsheet into the Lotus Notes email body. Any help would be greatly appreciated! Keith- Hide quoted text - - Show quoted text - Excellent article, however, this creates a picture of the worksheet. I actually want to either create a Lotus Notes embedded table or embed the worksheet as an object in the email body. In this manner, the user can manipulate the worksheet. Thanks for that site! It is a really great site and I will be using it in the future! |
All times are GMT +1. The time now is 08:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com