Forum home » Delegate support and help forum » Microsoft Access Training and help » E-mailing from Access

E-mailing from Access

ResolvedVersion 2007

Thu 10 Nov 2011, 14:16 Delegate Sarah said...

Sarah has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

E-mailing from Access

Hi, in my database I have created a query to make a table of delegates on a particular course. The table includes their email addresses. Is there a way to email directly from Access or do I have to copy and paste the email addresses into Outlook?

Fri 11 Nov 2011, 13:51 Trainer Anthony said...

RE: E-mailing from Access

Hi Sarah, thanks for your query. That's a little more complicated than you might think! Here are a couple of links with the information, but be warned involves some code....:

http://www.peterssoftware.com/c_emfa.htm

http://www.jephens.com/2007/05/13/how-to-send-e-mail-from-ms-access-using-outlook/

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

E-mailing from Access

E-mailing from Access

RE: E-mailing from Access

Access articles

Access tip:

Hiding Multiple Table columns