View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Macro to send email through Lotus Notes

Can you post the code you use now

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



"PCLIVE" wrote in message ...
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" wrote in message ...
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<BDear 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" wrote in message ...
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" wrote in message ...
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" wrote in message ...
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