changing mail accounts using VBA

[spurs100]

Hi everyone,

dont know if this is a simple thing?

is it possible to use VBA to change the from address field.

I currently have access to 2 mail accounts:

1. me@company.com
2. sales@company.com

i have a macro set up that opens a template response, however when i send this, it gives my email address not the sales address how can i make sure that the reply is sent using the sales address?

hope someone can help.

thanks in advance