| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alias FROM: when sending mail in Excel
The user wants to send a portion of the worksheet as the
body of an email. I found this code that does just that: ActiveSheet.Range("A1:K71").Select ActiveWorkbook.EnvelopeVisible = True With ActiveSheet.MailEnvelope .Item.To = AddressList .Item.Subject = "Test Subject" .Item.Send End With Great. But, the email shows the user's Exchange account name in the FROM: field. They want an alias name to show. Does someone know how I can choose what to display in the FROM: field of the email message? tod |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Alias FROM: when sending mail in Excel
Try item.SentOnBehalfOfName
"Tod" wrote: The user wants to send a portion of the worksheet as the body of an email. I found this code that does just that: ActiveSheet.Range("A1:K71").Select ActiveWorkbook.EnvelopeVisible = True With ActiveSheet.MailEnvelope .Item.To = AddressList .Item.Subject = "Test Subject" .Item.Send End With Great. But, the email shows the user's Exchange account name in the FROM: field. They want an alias name to show. Does someone know how I can choose what to display in the FROM: field of the email message? tod |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sending multipul e-mail from excel | Excel Discussion (Misc queries) | |||
| Sending One Cell Through Mail from Excel | Excel Worksheet Functions | |||
| General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
| Sending Mail from within Excel | Excel Programming | |||
| Sending mail from excel with CDO | Excel Programming | |||
Linear Mode
