Access SendObject and From Address

[Mark]

I have searched the web and every time this question is asked there is simply
no reply!

I want to send an object from access but have a different "From"/"Reply To"
address (eg "Sales" instead of the senders own address). This does not seem
to be a function of SendObject but maybe it could be achieved in Outlook.

The Access Group suggested I post here! Any suggestions?

 

[Sue Mosher [MVP-Outlook]]

Maybe you're getting no replies because you're asking in the wrong group.
There is a newsgroup specifically for general Outlook programming issues
"down the hall" at microsoft.public.outlook.program_vba or, via web
interface, at
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba

You are correct that if you use Outlook objects, you can set the ReplyTo
address using the MailItem.ReplyRecipients collection.