PC Review


Reply
Thread Tools Rate Thread

Automatically Send Email based on query

 
 
=?Utf-8?B?U2FmaS4=?=
Guest
Posts: n/a
 
      28th Mar 2007
Hi,
I was given enligtment to solve this problem of my boss who is supposed to
mail and co-ordinate with lot of people at different locations.....My data is
like

S.No Location Date of Filing Remarks Emails
1. AC 27-Mar-2007 No
(E-Mail Removed)
2. DC 27-Mar-2007 No
(E-Mail Removed)
3. FC 31-Mar-2007 Yes
(E-Mail Removed)

>> He has to send emails to location right 3 days before from the date of filing...about imforming the person that we are filing these to the email addresses present in the Emails column for every 3 hours...till the date mentioned in the column "Date of Filing"... and upto when it was turned yes in the "Remarks" Column.


shud this be possible...a macro or ...

Regards,
Safi.
 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      28th Mar 2007
Hi Safi

Try the example on my site
http://www.rondebruin.nl/mail/folder3/message.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Safi." <Safi.@discussions.microsoft.com> wrote in message news:6C163E79-023C-4778-B14E-(E-Mail Removed)...
> Hi,
> I was given enligtment to solve this problem of my boss who is supposed to
> mail and co-ordinate with lot of people at different locations.....My data is
> like
>
> S.No Location Date of Filing Remarks Emails
> 1. AC 27-Mar-2007 No
> (E-Mail Removed)
> 2. DC 27-Mar-2007 No
> (E-Mail Removed)
> 3. FC 31-Mar-2007 Yes
> (E-Mail Removed)
>
>>> He has to send emails to location right 3 days before from the date of filing...about imforming the person that we are filing
>>> these to the email addresses present in the Emails column for every 3 hours...till the date mentioned in the column "Date of
>>> Filing"... and upto when it was turned yes in the "Remarks" Column.

>
> shud this be possible...a macro or ...
>
> Regards,
> Safi.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create script to automatically send emails based on a query Jonathan Brown Microsoft Access VBA Modules 4 6th Feb 2009 05:56 PM
Automatically send email based on date value Eric Microsoft Access Forms 2 26th Oct 2007 11:46 PM
Send Reports based on Query to Printer Automatically Jeff Byrd Microsoft Access Reports 5 1st Aug 2006 01:59 AM
automatically send email in excel based on value/macro guru stuff =?Utf-8?B?TWljaGFlbCBB?= Microsoft Excel Programming 2 14th Jun 2005 09:08 PM
Send an email automatically based on value of field John Conklin Microsoft Access 1 29th Dec 2004 11:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:27 PM.