I am building automated email messaging, populating the Subject, message and
recipients from within my application. I need to popultat the From: also,
does anyone know how to code this?

Populate the From with what value? In what version of Outlook?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"dmklaus" wrote in message ...
I am building automated email messaging, populating the Subject, message and
recipients from within my application. I need to popultat the From: also,
does anyone know how to code this?

Outlook 2003, the sender would be a mailbox (for example:
)

"dmklaus" wrote:

I am building automated email messaging, populating the Subject, message and
recipients from within my application. I need to popultat the From: also,
does anyone know how to code this?

An Exchange mailbox? In that case, assign the mailbox alias or SMTP address to the MailItem.SentOnBehalfOfName property.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"dmklaus" wrote in message ...
Outlook 2003, the sender would be a mailbox (for example:
)

"dmklaus" wrote:

I am building automated email messaging, populating the Subject, message and
recipients from within my application. I need to popultat the From: also,
does anyone know how to code this?

Here's some sample code I use in Excel to send emails using Outlook.


Dim Outlook As Outlook.Application
Dim OutlookMsg As Outlook.MailItem
Dim OutlookRecip As Outlook.Recipient
Dim OutlookAttach As Outlook.Attachment

Set Outlook = CreateObject("outlook.application")
Set OutlookMsg = Outlook.CreateItem(olMailItem)

With OutlookMsg
.SentOnBehalfOfName = "
.ReplyRecipients.Add
")
.Subject = "Read me!"
.Importance = olImportanceHigh
.Sensitivity = olConfidential
.BodyFormat = olFormatHTML
.HTMLBody = "Your message here"

Set OutlookRecip = ")
OutlookRecip.Type = olTo

Set OutlookAttach = .Attachments.Add("C:\Documents And
Settings\username\Desktop\filename.xls")
.Send ' or .Display if you want to preview the message

'destroy variables
Set OutlookRecip = Nothing
Set OutlookAttach = Nothing
Set OutlookMsg = Nothing
Set Outlook = Nothing


Beware Outlook security warning!



HTH,
JP

On Nov 2, 9:23 am, dmklaus wrote:
Outlook 2003, the sender would be a mailbox (for example:
)



"dmklaus" wrote:
I am building automated email messaging, populating the Subject, message and
recipients from within my application. I need to popultat the From: also,
does anyone know how to code this?- Hide quoted text -

- Show quoted text -