mail from simple report or form

[briegull]

I am helping a nonprofit senior college with their Access database for class registrations. I've used Access in the past but it's changed a fair amount. We have a form which produces an acknowledgement of courses registered, includes person's name, etc. I want that to be emailed to the person. There are no macros set up.

When I click on the Email button at the top it asks me to choose the format so I choose pdf, and it produces an email BUT it doesn't recognize the Outlook mail client, it doesn't put the person's email in place or a subject. How do I do those things so it's basically a one-click operation? If I google a way, I find a lot of rather dense macros to use but this is a one-off. I don't want to take a class to set up this one thing. SO:
a) any way to set the email button at the top to choose PDF so the data entry person doesn't have to scroll through the list of all possible formats every time?


b) Any way to read the email address from the student's record? Put in a subject?
c) Any hints about connecting to the Outlook program? It doesn't seem to FIND it and I can't find a preferences panel as I do in Excel and Word to set that sort of thing.

[ItsMe]

Sounds like you need to Automate Outlook via Access.

Here is one example.
https://www.accessforums.net/access/...tml#post281575

[lzook88]

look at the docmd.sendobject in Access VBA..


https://msdn.microsoft.com/en-us/lib.../ff197046.aspx

Z