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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>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" <rondebr...@kabelfoon.nl> 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" <KeithOwenRobe...@gmail.com> wrote in messagenews:(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> On Feb 15, 10:04 am, "Ron de Bruin" <rondebr...@kabelfoon.nl> 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" <KeithOwenRobe...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>> >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!
>