I have an MS ACCESS db setup with the ability to send out e-mail, attach files, cc and bcc. The problem I have is I need the replace the "From" field from the Notes address that sent it to a string that I have specified. I have already tried using .From, .Principle, and .Sender. The .From will replace the value but from what I can tell this is only true if the recipient has Notes, I have been testing this app using hotmail, and yahoo. Both of these show me the address that sent it(not what I want). Just so you know this is not a spam app, the e-mail that will be sent out is reminders of expiring passes and permits to people that requested a reminder.
Thanx in advance
Thanx in advance