By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

send Outlook email from different name?

P: n/a

Is there a way to set the FROM name (the name the recepient sees as the
one who sent the email) when using Access to create an Outlook email
message? (Using MS-Office 2000 SP3)

We set up an anonymous account to send survey messages to our customers
in the company-wide address book, but can I set the message to be sent
from that account in code? It always defaults to the normal (default)
"From" name Outlook sender.

Here's my code so far:
Dim myOlApp As Object
Dim myEmail As Outlook.MailItem
Dim strDocName As String

Set myOlApp = CreateObject("Outlook.Application")
Set myEmail = myOlApp.CreateItem(olMailItem)

With myEmail
'Set Sender Name Here (doesn't work)
'.From = "Anonymous Account Name"
.To = Me![CustEmail]
.Subject = "Auto-Email"
.Body = "...Message Body..."
End With

Thanks for any help,

~Joshua Ammann

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Found the answer. If anyone else is interested:

With myEmail
.SentOnBehalfOfName = "Anonymous Account Name"
End With
~Joshua Ammann

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.