Email Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure if its possible, is there any way to have access "remind" people
via email to complete a form once a week?
 
Lori said:
I'm not sure if its possible, is there any way to have access "remind" people
via email to complete a form once a week?
Click to expand...

Using VBA code, with a query which looks at the tickler date based on
todays date. loop through the recordset to send the emails, and a
sent date. Repeat next week,.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm


--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email a reminder inAcces VBA 2
Outlook Popups / email alerts in Access DB 0
Prefilled Outlook Yes Voting Button response 0
Emailing Access 2003 Reports 4
Please help: Send object when argument satisfies 1
Automated Email 1
Access and Outlook Reminders 2
is there a way to use an access database to send group emails 1

Back
Top