[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Email from access 2003

Posted on 2012-03-15
4
Medium Priority
?
235 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 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

872 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