Question Send Form Information to email

[dionicia]

Hi.

My boss asked me to create a database which will email out to individuals their performance results, but he doesn't want everyone to see each others results. He ultimately wants to enter the information, hit a button and have the results be sent to that individual via email without having to do extra work in Outlook. It seems pretty straight forward until I get to the part about sending out the emails.

My problem is I am not sure if I should use a macro or visual basic code to send the emails. Is it possible to create a macro to send individual form information or would it be better to create code?

I tried to search through the threads on here, but didn't find one that fit the bill. Any direction at this point would be immensely helpful. I don't know anything about visual basic so I am still in the beginning learning phases there.

Thank you.

 

[HiTechCoach]

I would create a report for printing the data.

you could try using sendobject to email each individual report.

this may help

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

 

[G81]

I would tend to do something like that by vba, as it would require no maintanance.

With a macro you would probably do a separate SendObject for every worker, which would send out thier own table, report, excel spreadsheet, etc. But you would have to add new workers into the macro when needed.

With vba, as long as you have a table with workers and their email addresses, you could loop around, build custom queries to grab individual performance, send an email, and anything else you want to do.