Hi all,
I have seen an answer to this recently, I think on this forum even, but it was not what I was looking for at the time so I ignored it, and now after much searching I can no longer find it!
So apologies for the new thread but I am hoping someone will be generous enough to answer this for me:
I am sending emails from a command button on a form, and it works fine. However, I want to change the From field so that it is not sending from my default address but from another mailbox to which I have access. The address can be hardcoded into the script because it will not change. Can anyone post a brief bit of code showing how to set the From field when creating an email from Access? I can't even find it in the object browser...
I am using Access 2003 and MS Outlook.
Many thanks for any help!
I have seen an answer to this recently, I think on this forum even, but it was not what I was looking for at the time so I ignored it, and now after much searching I can no longer find it!
So apologies for the new thread but I am hoping someone will be generous enough to answer this for me:
I am sending emails from a command button on a form, and it works fine. However, I want to change the From field so that it is not sending from my default address but from another mailbox to which I have access. The address can be hardcoded into the script because it will not change. Can anyone post a brief bit of code showing how to set the From field when creating an email from Access? I can't even find it in the object browser...
I am using Access 2003 and MS Outlook.
Many thanks for any help!
