Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Capture email sender address

Status
Not open for further replies.

dmh4ab

Programmer
Oct 2, 2002
53
US
Is there a way to capture the sender's email address when using Outlook to send email through Access97?

Regards,
dmh4ab
 
I have a function that i use on forms via
runcode=send_email(......). May be this will help

Public Function SEND_EMAIL(TOEMAIL, CCEMAIL, SUBJ, BODY)
Set objOutlook = CreateObject("Outlook.application")
Set objEmail = objOutlook.CreateItem(olMailItem)

With objEmail
.TO = TOEMAIL
.cc = CCEMAIL
.Subject = SUBJ
.BODY = BODY
.SEND
End With

Set objEmail = Nothing

End Function

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."
 
I have the function written that works great. However, I wish to capture the address that it was sent from so that I can store it and easily send an email back to the original sender later on.

dmh4ab
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top