How to Change the Sender account or reply to in outlook

[simulationguy]

I have some vba code to create an outlook appointment and send it to users in a list, but I would like to change the sender account or the email address that gets the reply when the appointments are accepted or rejected.

Basically a PM may send out the request but instead of getting 100 responses back we would like the responses to go to another email address (shared account). I think there is a way to change

Getting the appointments sent to a shared calendar is working okay but I cant seem to change the reply

[pod]

The answer lies in your question. Add an extra e-mail account in Outlook for the PM, the shared email address you are referring to. And propose to the PM to use it when making outlook appointments, then all replys will go to it. Talk to your IT dept about setting it up.

But if you are adamant to change the sender account from your VBA code, I never had the need to do this, therefore I cannot help you but I am certain someone did this before.

Good luck

[zmbd]

Are you doing this from MS Access?

IF not then you might have some issues getting any real help with the question in this forum as it pertains to MS Access and vba /sql code dealing with MS Access.

If you are doing this from MS Access then you will need to post your code that you've currently developed and I'm sure that someone here will be able to help.

Please make sure that you use the required [CODE][/CODE] tags around your code.

-z

[simulationguy]

Thanks the secret was that I had to have everyone get permissions for the shared email account. The MS Access database then sends the outlook appointments out for any of the users but all the replies go back to the shared mailbox. It worked fine after I got the permissions changed. Thanks!

[NeoPa]

We do actually allow any MS Office-based questions in here as many of those who know Access tend to have at least a passing acquaintance with other Office apps. This is the most appropriate forum for such questions, though perhaps that isn't made as clear as it could be ;-)