| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to send email through Lotus Notes
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to send email through Lotus Notes
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to send email through Lotus Notes
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to send email through Lotus Notes
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign a macro to send email in lotus notes from Excel spreadsheet | Excel Worksheet Functions | |||
| How do I send an Excel workbook through Lotus Notes Email? | Excel Discussion (Misc queries) | |||
| Send Mail with Lotus Notes | Excel Discussion (Misc queries) | |||
| Excel VBA to send email using Lotus Notes | Excel Programming | |||
| Send email with Lotus Notes | Excel Programming | |||
Hybrid Mode
