Question sending email from Access

[PaulSpell]

I have a function that uses SendObject to send emails to a number of different email addresses. The problem is that I want to also vary the sender email address (as I have numerous email addresses that I use).

How can I get Access to send an email using a from address that I specify (can it be done)?

Thanks.

 

[David b]

Sounds like you need a form which displays all the addresses you have. A check box would alllow you to select the ones you wanted. Then the record source for your email routine would be a query picking up addresses you had previously marked.
HTH
David b

 

[PaulSpell]

David,

I have all that working, but it's the bit about changing the senders address that I am stuck on, Docmd.SendObject doesn't seem to do it?