Solved

Email from access 2003

Posted on 2012-03-15
4
220 Views
Last Modified: 2012-04-15
How do I send emails from access 2003. I have the emails in a query and want to send them with the same subject and text. Thanks. Either with outlook 2003 or without.
0
Comment
Question by:jontyplatt
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
Neil Russell earned 500 total points
ID: 37726815
Read this for how to send emailmails using VBA & CDO from Access.

http://www.rondebruin.nl/cdo.htm

Anything you dont understand just ask.
0
 
LVL 8

Expert Comment

by:csoussan
ID: 37726865
There is a built in feature called smart tags that will do various things like send email, create appointments, open contacts, etc.

Add a Smart Tag to a Control on a Form, Report, or Data Access Page
------------------------------------------------------------------------------------------------------------

  1. Open the form, report, or data access page in Design View.
  2. Select a control and then click Properties  on the toolbar to open the
      control's property sheet.
  3. Click on the Data Tab.
  4. In the SmartTags property box, do one of the following:

Click the Build button  in the SmartTags property box to open the Smart Tags dialog box. Click the smart tag that you want to add to the control, and then click OK.
Type the namespace Uniform Resource Identifier (URI) for the smart tag in the SmartTags property field. (Select PersonName)

http://office.microsoft.com/en-us/access-help/add-a-smart-tag-to-a-control-HP001032672.aspx
0
 
LVL 8

Expert Comment

by:csoussan
ID: 37742229
Hi jontyplatt,

Any update on your issue?
0
 

Author Comment

by:jontyplatt
ID: 37763201
Thanks Neilst - that works - I assume that the code is the same in Access?

I have been struggling with this on and off for years - I wrote a database my the sailing club 10 years ago and they keep pestering me to do this update and I have been unable to get it to work - so thanks

sorry for the late reply - I have a day job and I am doing this update to the database for free!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now