VBA, Lotus Notes 8.5, and Anonymous Senders

[schaefd2]

Hello,

I am building an Access 2007 form where coworkers can submit feedback to management anonymously. Once they have typed in their feedback, they click a button which submits the feedback into a table and also sends an email through Lotus Notes 8.5 to my manager notifying him of new feedback.

I was able to have Access and VBA automatically send an email through LN, but the name of the sender appears in the recipient's inbox. This defeats the purpose of having Anonymous Feedback.

Does anyone know how I can program, using VBA, so that the sender's name is hidden, randomized, anonymized, or otherwise rendered unknown to my manager?

I am open to any and all suggestions.

Thanks!!

 

[mdlueck]

Perhaps have some automated process scan the feedback table for new records, and skip trying to locate a solution to have Notes send anonymously.

Could design a query to select out records within the last 24Hr if you have a timestamp column showing when the record was added to the table.

 

[schaefd2]

My manager is rarely using the Access database and he would like some way of getting a notification of new feedback without having to actually open the database and check himself. Right now, an anonymous email seems to be ideal, but I can't hide the sender.

 

[mdlueck]

So build a DB to EMail bridge process... scan the DB, send your boss emails as needed. That way the sender of the email would be the automated process, not who actually submitted the feedback.

Have this process run on some computer which is guaranteed to be on all the time.