Hello,

I am trying to generate an email from an Access database when the user clicks a button on a form. I need it to pull records from a table where the records equal the value chosen in a combo box. Right now, this code below will pop just an email with the information after the Set objoutlook line. Nothing from the query is pulled.

I had to attach my code as a .docx because the forum wouldn't let me post it for some reason.

I would greatly appreciate some help. Thanks in advance.

vbacode.docx