| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
write email subject
Hi,
How do i write a marco to populate the email subject with "Here it is" if i am sending email from excel? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
write email subject
HI Lynn
This works for me ActiveWorkbook.SendMail ,Subject:="This is IT!" Best N10 "Lynn" wrote in message ups.com... Hi, How do i write a marco to populate the email subject with "Here it is" if i am sending email from excel? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
write email subject
ActiveWorkbook.SendMail will send the worksheet straight away.
I only need to input "This is IT" into the subject field. any idea? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
write email subject
Whats you existing code like?
N10 "Lynn" wrote in message oups.com... ActiveWorkbook.SendMail will send the worksheet straight away. I only need to input "This is IT" into the subject field. any idea? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
write email subject
With SendMail the only way is not to fill in a e-mail address
.SendMail "", "This is the Subject line" If you use the Outlook Object model you can use Display instead of Send See the examples on my site http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "N10" wrote in message ... Whats you existing code like? N10 "Lynn" wrote in message oups.com... ActiveWorkbook.SendMail will send the worksheet straight away. I only need to input "This is IT" into the subject field. any idea? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| email hyperlink - cell value in subject line | Excel Discussion (Misc queries) | |||
| Email subject | Excel Discussion (Misc queries) | |||
| Using VB, specific cell data into email subject | Excel Discussion (Misc queries) | |||
| Defining the subject of an Email by value in range | Excel Programming | |||
| Code to Email with UNC in subject line | Excel Programming | |||
![Lynn[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
