Send an E-mail and specify the FROM

[rockies1]

I have a user that needs to send e-mails via VBA in Access.

They don't want the e-mail to appear to come from them, however.

They have another e-mail box (Outlook98 on Excahnge) that they can put in the FROM box, and it then comes from that mailbox.

How can I do the same via Access VBA?

Thanks!

(I do know how to send e-mails via VBA, so I don't necessarily need that code...Just the FROM part)

 

[J-F]

I don't think it can be done in code. The easiest way is to set your default account in Outlook before you run the procedure.
You can then reset the default to whatever it was before.

 

[rockies1]

I haven't had any luck with the code either.

Because this will be a real-time e-mail, I can't change the default account. The users will normally be sending under their own name and only occasionally under this other name...