Outlook email via VBA in Access

[vjacobie]

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.

[RobDog888]

Welcome to the Forums.

Well this is the issue. First its not allowed to create an app on the Forums that alias' email addresses as it could be used
for spam or malicious acts.

Probably the best solution is to actually get an email address and domain .com name. Its relativly inexpensive and
when they want to reply to your ad it will go to a valid address so you can get the feedback.

Maybe you could get pppsshops.com as a domain name and set up an address or [email protected]. It would
look more professional too.

[vjacobie]

Thanks for the advice. Much appreciated.

The reason I asked is because I work for a debt collection agency, and we do bulk emailing to the debtors that we have on our books, and we now want to set it up that each individual collector can also email a debtor, but we want all the replies to go to one mailbox, and in order to do that we need the "From" to be from our legal departments email address, instead of the individual collectors email address.

[RobDog888]

Oh ok, then maybe something like a delegate is what your saying you may need? There is also Exchange scripting in case you want
to just route the emails to each particular mailbox depending on some criteria.

[salvelinus]

You can send debtors emails? Wouldn't that violate some privacy provision of some Fair Credit or Collection act? The email could be read by others at several points along the way. I'd think twice about this project.