ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to inserting text in thos email macro (https://www.excelbanter.com/excel-programming/334559-how-inserting-text-thos-email-macro.html)

stric[_2_]

How to inserting text in thos email macro
 

Please seethe following macro that sends a mesage only with osmething
written in subject line:

SUB SENDIT()
APPLICATION.DIALOGS(XLDIALOGSSENDMAIL).SHOW _
\", _
ARG2:=\"THIS GOES IN SUBJECT LINE\"
END SUB

How can I add text to the body of this message?
arg3?
Please help me here.
Thanks


--
stric
------------------------------------------------------------------------
stric's Profile: http://www.excelforum.com/member.php...o&userid=25230
View this thread: http://www.excelforum.com/showthread...hreadid=387225


Ron de Bruin

How to inserting text in thos email macro
 
You need other code to do this

See my site for example code
http://www.rondebruin.nl/sendmail.htm


Look for the Outlook example
http://www.rondebruin.nl/mail/folder3/smallmessage.htm

Or see the OE example
http://www.rondebruin.nl/mail/oebody.htm


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


"stric" wrote in message
...

Please seethe following macro that sends a mesage only with osmething
written in subject line:

SUB SENDIT()
APPLICATION.DIALOGS(XLDIALOGSSENDMAIL).SHOW _
\", _
ARG2:=\"THIS GOES IN SUBJECT LINE\"
END SUB

How can I add text to the body of this message?
arg3?
Please help me here.
Thanks


--
stric
------------------------------------------------------------------------
stric's Profile: http://www.excelforum.com/member.php...o&userid=25230
View this thread: http://www.excelforum.com/showthread...hreadid=387225





All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com