Using Record Set to send emails using field values as part of body

[cebella2]

Hey all,

I've recently started a new job and I'm required to help an individual here automate her denial/approval email process with regards to academic appeals. I can't give out actual information due to FERPA and a thousand other policies so I'll have to deal in fictional data.

Basically my idea is to set up a macro from a command button that queries a table that has records of each appeal that has been submitted. Using a term code and if it was approved or not to get two sets of data... the approves and the denies. I invision this set up in two different queries as it would need two different email responses. All of this I can do to get to the recordsets. Once they are available I'm assuming I need VBA Code to pull email address, name, and reason for denial from the recordset.


The current table that I'm using is structured as such:
Term Code: text
Last Reviewed: Date/Time
Student Name: Text
UniversityID: Text
Email: Text
Approved: Yes/No
Denied: Yes/No
Notified?: Yes/No
Reason Denied: Text

I want at the push of two different buttons that macros take and input the fields into emails to personalize them and send out individual emails.

Any and all help is appreciated. If i haven't been clear or it would help to have more information please let me know.

Thanks!
Chris

 

[carl6885]

Are you sending the emails automatically though Access via Outlook?

 

[cebella2]

Yes,

Currently using MS Access 2010 and hoping to utilize MS Outlook 2010.

 

[carl6885]

Think you could achieve this with one button, two record sets (one for each query).

To be clear are you looking for example code covering record set and outlook or just the outlook ode?

Thanks

 

[cebella2]

Think you could achieve this with one button, two record sets (one for each query).

To be clear are you looking for example code covering record set and outlook or just the outlook ode?

Thanks

I'm what I would call an advanced novice at VBA so I was hoping that somebody could provide me some basics of code, or if anybody is doing the same thing in a database they are using and can provide the code to get me in the right direction. Usually when I have something to start with I can learn it enough to understand the process.

 

[carl6885]

What is your email?

I will send you a db I am working on for work (with no data in) that uses recordsets and email automation which works that should give you something to work with... you can pm if preferred.

 

[cebella2]

It's my user name @uncg.edu


I hate to do it that way but it doesn't seem like it's letting me PM you.