Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rating: Thread Rating: 11 votes, 5.00 average. Display Modes
Old 02-15-2012, 08:51 AM   #1
Xiqa
Newly Registered User
 
Join Date: Feb 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Xiqa is on a distinguished road
Automated Email Macros; Access>Word>Outlook

I found out only last week that Access has the capability to send emails utilizing Word and Outlook. We have the Office 2010 bundle.

My problem is this:
We have over 200 staff members at a newly opened organization and my boss is having problems with setting up a system that will receive queries to an email address and subsequently send out an email detailing informations from our access database using a line of code in said email to communicate with access.

The information for example would be credential expiration dates, and the query would be for who's information that would expire within two weeks from the date the email request was being sent.
I know the rough basics of a server needing to be set up and connected and connectable through internet, and about a few macros and coding not specific to Access.
If there is a website with code definitions and a guide on setting up email-to-Access-to-email messaging, that would be moderately helpful, but I love information straight from the horses mouth.
All prior searches through Google yielded applicable but vague information.


TL;DR
Need to set up outlook-to-access-to-word-to-outlook system to automate requests in code to retrieve Access database information. Anyone able to hand-hold for roughly two days on subject, or post link that already explains?


Last edited by Xiqa; 02-15-2012 at 08:59 AM.
Xiqa is offline   Reply With Quote
Old 02-16-2012, 04:07 AM   #2
Trevor G
Newly Registered User
 
Trevor G's Avatar
 
Join Date: Oct 2009
Location: Tamworth, Staffordshire
Posts: 2,331
Thanks: 4
Thanked 229 Times in 219 Posts
Trevor G will become famous soon enough Trevor G will become famous soon enough
Re: Automated Email Macros; Access>Word>Outlook

Welcome to the forum,

It sounds as though you could use Mail Merge to achieve this, Mail Merge in Word will allow you to use the Send Email Merge, therefore you could connect a query to use as the source and then the list could be sent out to individuals.

You wouldn't need to use VBA to do this which should make life easier.

To see if this is a viable solution for you Open Microsoft Word and then Select the Mailings Tab, in this tab Select Start Mail Merge and at the bottom select the Wizard. As you navigate the instructions on the right it should guide you.
__________________
Trevor
I am on a learning curve of life, I know a little but like to share what I have learnt with others.
I am using Microsoft Office 2003 To 2016
Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.
Trevor G is offline   Reply With Quote
Old 02-16-2012, 06:08 AM   #3
Xiqa
Newly Registered User
 
Join Date: Feb 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Xiqa is on a distinguished road
Re: Automated Email Macros; Access>Word>Outlook

Quote:
Originally Posted by Trevor G View Post
Welcome to the forum,

It sounds as though you could use Mail Merge to achieve this, Mail Merge in Word will allow you to use the Send Email Merge, therefore you could connect a query to use as the source and then the list could be sent out to individuals.

You wouldn't need to use VBA to do this which should make life easier.

To see if this is a viable solution for you Open Microsoft Word and then Select the Mailings Tab, in this tab Select Start Mail Merge and at the bottom select the Wizard. As you navigate the instructions on the right it should guide you.
Thank you, Trevor. I will check this as soon as I am at a computer. Do you know if your recommended POA requires manual entry of request through Access, or Word?

Xiqa is offline   Reply With Quote
Old 02-16-2012, 06:44 AM   #4
Trevor G
Newly Registered User
 
Trevor G's Avatar
 
Join Date: Oct 2009
Location: Tamworth, Staffordshire
Posts: 2,331
Thanks: 4
Thanked 229 Times in 219 Posts
Trevor G will become famous soon enough Trevor G will become famous soon enough
Re: Automated Email Macros; Access>Word>Outlook

If you create the document in Word then you only run this when you need to, so it acts like a template and once you open it, it will reconnect to the Database and the query.

You can automate this in Access to Open the word document, but give it a go first to see if it is a viable option.

Post back with any questions.

__________________
Trevor
I am on a learning curve of life, I know a little but like to share what I have learnt with others.
I am using Microsoft Office 2003 To 2016
Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.
Trevor G is offline   Reply With Quote
Reply

Tags
automated , email , macro , outlook , word

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automated Email using Outlook Eightball3 Modules & VBA 2 08-18-2010 06:45 AM
Extracting email body to Word (Outlook) Mike375 Modules & VBA 17 07-19-2009 04:41 AM
Automated Outlook email in batches millwheal Modules & VBA 3 02-05-2009 04:28 AM
Outlook AUtomated email with the "Program sending email on your behlaf " warning paulmcdonnell Modules & VBA 5 07-27-2005 10:11 AM
Word document as body of outlook email message Jimmy Modules & VBA 0 05-26-2005 10:53 AM




All times are GMT -8. The time now is 07:05 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World