Unanswered: automated email sent from records in form
I have a form that contains print job information. I would like a command button on the form that will send print charge information to our companies finance department when a job is complete. I want the email to be sent from Microsoft Access. The email will always go to the same person, the email subject will always be the same, and the body of the email would come from the following fields;
CustomerName; Department; NumPrints; PrintSize; CostCode. (which i have put into a query)
Ideally i would like this process to be fully automated. But at the moment i will settle for anything.
I have looked at alot of code, which i have tried to slot into my own data but nothing is working. Im finding the code quite confusing?