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

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

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!

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!