Email in Access

[Guest]

I have a table set up like this:
FirstName - LastName - EmailAddress - TakenClass? (yes/no type)

I have a query that searches for all records where TakenClass? = yes

I am trying to send an email to each person where TakenClass? = yes.

I set up a Data Access Page to look like the body of the email that I want
to send. The beginning of the body of the email should say "To: "+FirstName.
I want to send out the page to everyone whose taken the class (automatically
getting the email address from the EmailAddress column) and I want to
automatically fill in the first name.

Can I create a macro that does this? If not, how can I implement this?

 

[Arvin Meyer]

You can't do it with a macro, but you can with code. You'll need the
Redemption Library or the security warnings will block each email you try to
send. I suggest you ask this in one of the Outlook newsgroups since it
involves circumventing the security warnings in Outlook and Exchange. There
are commercial products which will do this with Access, one of which is
Total Access Emailer:

http://www.fmsinc.com/Products/Emailer/index.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access