Hey there,

I would like to know if there is a way that you can change the name/email address of who the email comes FROM before sending it by using VBA code? E.G. my email addy is [email protected], but when I send an email (using a proc. setup up in an access database) I want the "From:" to read as "Peter's Pickled Peppers Shop" and the email addy must be "[email protected]"....

Any help you can provide will be very much appreciated.

Fanx,

Vince.