Emailing using Access

The UK's most regular instructor-led training courses.
Training information: 'ms access+course' · Access training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

1 post

ReplyMon 22 Jun 2009, 14:14Delegate Andrew said...

Andrew has attended:
Access Introduction course

Emailing using Access

How can I e-mail contacts directly from an Access 2007 database

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	5		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

870 posts

ReplyTue 23 Jun 2009, 12:40Trainer Rajeev said...

RE: emailing using Access

Dear Andrew

Thank you for attending Access 2007 Introduction course!! I hope you enjoyed the course and benefited from it.

There are two methods of doing this:

First Method is quite straight forward. You simply create a field and ensure that the data type you assign for it is Hyperlink.

Once you have typed the e-mails in this field you can simply click on any e-mail and as long as your Outlook is configured to send e-mails it will automatically open a new message dialog box with the recipient�s e-mail address enter fro you.

The second method relates to the new feature in Access 2007 called Create Emails. This is on the Ribbon under the tab External Data Tab within the Collect Data group.

This is used for sending emails to your clients that contains the forms which the recipients fill in and when they send it back to you can easily update your table which the form is based upon.

I am not sure if you will be using the e-mail for general mail shot or will it be for form filling.

My suggestion to you would be if you ware going to send it for mail shot then you can simply use the Mail merge facility of MS Word 2007 which allows you to send E-mails to multiple recipients.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

· The Benefits of Certified Microsoft Training in Access
· Have You Ever Wanted To Create A Combo Control On An Access Form?
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· How much time could you save with Access?
· What's In A Name? Creating A Company Personnel List Using Microsoft Access

Please browse our web site to find out more about
'ms access+course' and other Microsoft training courses.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips