K
Kevin Pitkin
Hi all,
I am experiencing a problem sending email messages using Outlook
Automation from Microsoft Access. I hope I'm asking in the right
group - I couldn't find an Outlook Automation group, so I'm hoping
that someone here might be able to help (or point me in the right
direction). I'm not even entirely sure it's an Outlook Automation
problem, but I'm hoping it might be, and that someone here might have
experienced the same. Apologies in advance if this is the wrong
place.
A key function of our database is to send emails to our customers to
update them on the status of their jobs, and we have been achieving
this by Outlook Automation for some time. However, the emails were
being sent to the customers from the database user's email account,
and management decided that the emails should be sent from a central
"Customer Service" email account. Our Systems Administrator altered
our Exchange setup so that the appropriate permissions were in place
and we altered the database code to send the mail on the behalf of the
Customer Services account, like so:
<snip>
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olMailItem)
Set ReplyRecipients = myItem.ReplyRecipients.Add("(e-mail address removed)")
With myItem
.SentOnBehalfOfName = "(e-mail address removed)"
.To = Me.email
.Subject = "Update"
.Body = Body
End With
myItem.Send
</snip>
This solution seemed to work well on the Outlook side-of-things,
however, the emails sent using this method are consistently bounced by
our Exchange:
<snip>
You do not have permission to send to this recipient. For assistance,
contact your system administrator.
MSEXCH:MSExchangeIS:/DC=local/DC=ouradname
urserver
</snip>
Our System Administrator is using the "I'm not a programmer, you're
not a systems guy, so we'll have to work together to resolve this."
line.
Sending emails manually in Outlook and changing the "From" field to
the Customer Service account does not produce this result.
We are using Microsoft Access/Outlook/Windows 2000 on some
workstations, Microsoft Office Access/Outlook 2003/Windows XP
Professional on others, and our server is running Small Business
Server 2003.
Any suggestions appreciated.
Thank you.
Kevin
I am experiencing a problem sending email messages using Outlook
Automation from Microsoft Access. I hope I'm asking in the right
group - I couldn't find an Outlook Automation group, so I'm hoping
that someone here might be able to help (or point me in the right
direction). I'm not even entirely sure it's an Outlook Automation
problem, but I'm hoping it might be, and that someone here might have
experienced the same. Apologies in advance if this is the wrong
place.
A key function of our database is to send emails to our customers to
update them on the status of their jobs, and we have been achieving
this by Outlook Automation for some time. However, the emails were
being sent to the customers from the database user's email account,
and management decided that the emails should be sent from a central
"Customer Service" email account. Our Systems Administrator altered
our Exchange setup so that the appropriate permissions were in place
and we altered the database code to send the mail on the behalf of the
Customer Services account, like so:
<snip>
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olMailItem)
Set ReplyRecipients = myItem.ReplyRecipients.Add("(e-mail address removed)")
With myItem
.SentOnBehalfOfName = "(e-mail address removed)"
.To = Me.email
.Subject = "Update"
.Body = Body
End With
myItem.Send
</snip>
This solution seemed to work well on the Outlook side-of-things,
however, the emails sent using this method are consistently bounced by
our Exchange:
<snip>
You do not have permission to send to this recipient. For assistance,
contact your system administrator.
MSEXCH:MSExchangeIS:/DC=local/DC=ouradname
urserver</snip>
Our System Administrator is using the "I'm not a programmer, you're
not a systems guy, so we'll have to work together to resolve this."
line.
Sending emails manually in Outlook and changing the "From" field to
the Customer Service account does not produce this result.
We are using Microsoft Access/Outlook/Windows 2000 on some
workstations, Microsoft Office Access/Outlook 2003/Windows XP
Professional on others, and our server is running Small Business
Server 2003.
Any suggestions appreciated.
Thank you.
Kevin