Macro to send email through Lotus Notes

Is there a way to control the text properties of the body text? For
example: bold, italics, underlined, etc.

I've got code like this to enter the body text.

.APPENDTEXT "This is a test."
.addnewline 1


Is there a way to have the macro control the text properties? Is it
possible to force "This is a test." to be bold in the email, via the macro?


Thanks,
Paul

Hi PCLIVE

You can look here for Lotus code
http://www.excelkb.com/?cNode=1X5M7A

Or use CDO
http://www.rondebruin.nl/cdo.htm
See Tips link also on that page


--
Regards Ron De Bruin
http://www.rondebruin.nl



"PCLIVE" <pclive@livenet.net> wrote in message news:uPjSOH6mGHA.1208@TK2MSFTNGP04.phx.gbl...
> Is there a way to control the text properties of the body text? For example: bold, italics, underlined, etc.
>
> I've got code like this to enter the body text.
>
> .APPENDTEXT "This is a test."
> .addnewline 1
>
>
> Is there a way to have the macro control the text properties? Is it possible to force "This is a test." to be bold in the email,
> via the macro?
>
>
> Thanks,
> Paul
>

Thanks Ron. It is some of your code that I originally used when I started
this project of zipping a file, attaching it to an email and sending it. I
appreciate all of your help in the past. However, I'm having trouble
grasping this one. I've looked at the code offered in your suggestions.
Unfortunately haven't found what I'm looking for. It doesn't seem that what
I am trying to do will be easy. I've had everything working without trying
to change the text appearance in the body of the outgoing email. However, I
now have the need to emphasize the text in different sections and thought
that it may be some simple coding. I guess it's not as simple as just
adding a few tag-lines to the .APPENDTEXT lines. If you have any other
suggestions, they are certainly welcome.

Thanks again.
Paul


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
news:OkQ0fN6mGHA.3588@TK2MSFTNGP04.phx.gbl...
> Hi PCLIVE
>
> You can look here for Lotus code
> http://www.excelkb.com/?cNode=1X5M7A
>
> Or use CDO
> http://www.rondebruin.nl/cdo.htm
> See Tips link also on that page
>
>
> --
> Regards Ron De Bruin
> http://www.rondebruin.nl
>
>
>
> "PCLIVE" <pclive@livenet.net> wrote in message
> news:uPjSOH6mGHA.1208@TK2MSFTNGP04.phx.gbl...
>> Is there a way to control the text properties of the body text? For
>> example: bold, italics, underlined, etc.
>>
>> I've got code like this to enter the body text.
>>
>> .APPENDTEXT "This is a test."
>> .addnewline 1
>>
>>
>> Is there a way to have the macro control the text properties? Is it
>> possible to force "This is a test." to be bold in the email, via the
>> macro?
>>
>>
>> Thanks,
>> Paul
>>
>
>

Have you try this ?

If you want to create emails that are formatted you can use HTMLBody (Office 2000 and up) instead of TextBody .
You can find a lot of WebPages on the internet with more HTML tags examples.

.HTMLBody = "<H3><B>Dear Ron de Bruin</B></H3>" & _
"Please visit this website to download an update.<BR>" & _
"<A HREF=""http://www.rondebruin.nl/"">Ron's Excel Page</A>"


--
Regards Ron De Bruin
http://www.rondebruin.nl



"PCLIVE" <pclive@livenet.net> wrote in message news:ucZf8%236mGHA.4572@TK2MSFTNGP05.phx.gbl...
> Thanks Ron. It is some of your code that I originally used when I started this project of zipping a file, attaching it to an
> email and sending it. I appreciate all of your help in the past. However, I'm having trouble grasping this one. I've looked at
> the code offered in your suggestions. Unfortunately haven't found what I'm looking for. It doesn't seem that what I am trying to
> do will be easy. I've had everything working without trying to change the text appearance in the body of the outgoing email.
> However, I now have the need to emphasize the text in different sections and thought that it may be some simple coding. I guess
> it's not as simple as just adding a few tag-lines to the .APPENDTEXT lines. If you have any other suggestions, they are certainly
> welcome.
>
> Thanks again.
> Paul
>
>
> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:OkQ0fN6mGHA.3588@TK2MSFTNGP04.phx.gbl...
>> Hi PCLIVE
>>
>> You can look here for Lotus code
>> http://www.excelkb.com/?cNode=1X5M7A
>>
>> Or use CDO
>> http://www.rondebruin.nl/cdo.htm
>> See Tips link also on that page
>>
>>
>> --
>> Regards Ron De Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "PCLIVE" <pclive@livenet.net> wrote in message news:uPjSOH6mGHA.1208@TK2MSFTNGP04.phx.gbl...
>>> Is there a way to control the text properties of the body text? For example: bold, italics, underlined, etc.
>>>
>>> I've got code like this to enter the body text.
>>>
>>> .APPENDTEXT "This is a test."
>>> .addnewline 1
>>>
>>>
>>> Is there a way to have the macro control the text properties? Is it possible to force "This is a test." to be bold in the
>>> email, via the macro?
>>>
>>>
>>> Thanks,
>>> Paul
>>>
>>
>>
>
>

I did try that before, but I just tried it again with the same result.

I get an error stating:
"Error # 438 was generated by VBAProject
Object doesn't support this property or method"

I'm not sure if there is something else I need in order to use the .HTMLBody
option.


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
news:uxch4E7mGHA.4960@TK2MSFTNGP04.phx.gbl...
> Have you try this ?
>
> If you want to create emails that are formatted you can use HTMLBody
> (Office 2000 and up) instead of TextBody .
> You can find a lot of WebPages on the internet with more HTML tags
> examples.
>
> .HTMLBody = "<H3><B>Dear Ron de Bruin</B></H3>" & _
> "Please visit this website to download an update.<BR>"
> & _
> "<A HREF=""http://www.rondebruin.nl/"">Ron's Excel
> Page</A>"
>
>
> --
> Regards Ron De Bruin
> http://www.rondebruin.nl
>
>
>
> "PCLIVE" <pclive@livenet.net> wrote in message
> news:ucZf8%236mGHA.4572@TK2MSFTNGP05.phx.gbl...
>> Thanks Ron. It is some of your code that I originally used when I
>> started this project of zipping a file, attaching it to an email and
>> sending it. I appreciate all of your help in the past. However, I'm
>> having trouble grasping this one. I've looked at the code offered in
>> your suggestions. Unfortunately haven't found what I'm looking for. It
>> doesn't seem that what I am trying to do will be easy. I've had
>> everything working without trying to change the text appearance in the
>> body of the outgoing email. However, I now have the need to emphasize the
>> text in different sections and thought that it may be some simple coding.
>> I guess it's not as simple as just adding a few tag-lines to the
>> .APPENDTEXT lines. If you have any other suggestions, they are certainly
>> welcome.
>>
>> Thanks again.
>> Paul
>>
>>
>> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
>> news:OkQ0fN6mGHA.3588@TK2MSFTNGP04.phx.gbl...
>>> Hi PCLIVE
>>>
>>> You can look here for Lotus code
>>> http://www.excelkb.com/?cNode=1X5M7A
>>>
>>> Or use CDO
>>> http://www.rondebruin.nl/cdo.htm
>>> See Tips link also on that page
>>>
>>>
>>> --
>>> Regards Ron De Bruin
>>> http://www.rondebruin.nl
>>>
>>>
>>>
>>> "PCLIVE" <pclive@livenet.net> wrote in message
>>> news:uPjSOH6mGHA.1208@TK2MSFTNGP04.phx.gbl...
>>>> Is there a way to control the text properties of the body text? For
>>>> example: bold, italics, underlined, etc.
>>>>
>>>> I've got code like this to enter the body text.
>>>>
>>>> .APPENDTEXT "This is a test."
>>>> .addnewline 1
>>>>
>>>>
>>>> Is there a way to have the macro control the text properties? Is it
>>>> possible to force "This is a test." to be bold in the email, via the
>>>> macro?
>>>>
>>>>
>>>> Thanks,
>>>> Paul
>>>>
>>>
>>>
>>
>>
>
>

Can you post the code you use now

--
Regards Ron De Bruin
http://www.rondebruin.nl



"PCLIVE" <pclive@livenet.net> wrote in message news:ei3GnK7mGHA.1208@TK2MSFTNGP04.phx.gbl...
>I did try that before, but I just tried it again with the same result.
>
> I get an error stating:
> "Error # 438 was generated by VBAProject
> Object doesn't support this property or method"
>
> I'm not sure if there is something else I need in order to use the .HTMLBody option.
>
>
> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:uxch4E7mGHA.4960@TK2MSFTNGP04.phx.gbl...
>> Have you try this ?
>>
>> If you want to create emails that are formatted you can use HTMLBody (Office 2000 and up) instead of TextBody .
>> You can find a lot of WebPages on the internet with more HTML tags examples.
>>
>> .HTMLBody = "<H3><B>Dear Ron de Bruin</B></H3>" & _
>> "Please visit this website to download an update.<BR>" & _
>> "<A HREF=""http://www.rondebruin.nl/"">Ron's Excel Page</A>"
>>
>>
>> --
>> Regards Ron De Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "PCLIVE" <pclive@livenet.net> wrote in message news:ucZf8%236mGHA.4572@TK2MSFTNGP05.phx.gbl...
>>> Thanks Ron. It is some of your code that I originally used when I started this project of zipping a file, attaching it to an
>>> email and sending it. I appreciate all of your help in the past. However, I'm having trouble grasping this one. I've looked
>>> at the code offered in your suggestions. Unfortunately haven't found what I'm looking for. It doesn't seem that what I am
>>> trying to do will be easy. I've had everything working without trying to change the text appearance in the body of the outgoing
>>> email. However, I now have the need to emphasize the text in different sections and thought that it may be some simple coding. I
>>> guess it's not as simple as just adding a few tag-lines to the .APPENDTEXT lines. If you have any other suggestions, they are
>>> certainly welcome.
>>>
>>> Thanks again.
>>> Paul
>>>
>>>
>>> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:OkQ0fN6mGHA.3588@TK2MSFTNGP04.phx.gbl...
>>>> Hi PCLIVE
>>>>
>>>> You can look here for Lotus code
>>>> http://www.excelkb.com/?cNode=1X5M7A
>>>>
>>>> Or use CDO
>>>> http://www.rondebruin.nl/cdo.htm
>>>> See Tips link also on that page
>>>>
>>>>
>>>> --
>>>> Regards Ron De Bruin
>>>> http://www.rondebruin.nl
>>>>
>>>>
>>>>
>>>> "PCLIVE" <pclive@livenet.net> wrote in message news:uPjSOH6mGHA.1208@TK2MSFTNGP04.phx.gbl...
>>>>> Is there a way to control the text properties of the body text? For example: bold, italics, underlined, etc.
>>>>>
>>>>> I've got code like this to enter the body text.
>>>>>
>>>>> .APPENDTEXT "This is a test."
>>>>> .addnewline 1
>>>>>
>>>>>
>>>>> Is there a way to have the macro control the text properties? Is it possible to force "This is a test." to be bold in the
>>>>> email, via the macro?
>>>>>
>>>>>
>>>>> Thanks,
>>>>> Paul
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>