I need to send auto Email by access VBA

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
I need to send auto Email by access VBA

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

December 8th, 2009, 06:18 AM

Anud

Anud is offline

Registered User

Join Date: Dec 2009

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Default

I need to send auto Email by access VBA

Hello all,

I need to help about the subject.

when the date in the table equal the sysdate

send remeinder to spacific user.

BR

Old

December 10th, 2009, 09:33 AM

SerranoG

SerranoG is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,151

Thanks: 2

Thanked 14 Times in 14 Posts

Send a message via ICQ to SerranoG

Send a message via AIM to SerranoG

Default

You can test today's date by using the Date() function. You can send them the e-mail by using the DoCmd.SendObject method.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Store procedure,auto send email after X days.(+asp	kumiko	SQL Server 2005	2	February 29th, 2008 01:15 PM
Excel VBA - Send email with html message body	elad	Excel VBA	1	July 16th, 2007 03:28 PM
auto tracker function &send personalised email	miracles	Excel VBA	1	April 27th, 2007 04:43 AM
Auto send email from command button	underscore10304	Access VBA	3	September 26th, 2006 06:41 AM
how to send email to outlool from Access	flyfish	Access	12	February 2nd, 2005 12:02 PM