Automating Task within Excel To Send Emails
 

We have a user who currently uses a simple spreadsheet to list certain types
of enquiries they get. They would like to set up a macro, or such, to enable
an automatic prompt, for example an email, to be sent to a member of staff if
something hasnt been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.

--
James

Automating Task within Excel To Send Emails
 

Hi,

Have a look at the excellent resource


http://www.rondebruin.nl/mail/templates.htm

Mike

"JamesW" wrote:

We have a user who currently uses a simple spreadsheet to list certain types
of enquiries they get. They would like to set up a macro, or such, to enable
an automatic prompt, for example an email, to be sent to a member of staff if
something hasnt been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.

--
James

Automating Task within Excel To Send Emails
 

Thanks Mike,

However what we need to do is for the task\macro to look at a cell, with a
date in it, and then compare it to the current date and if it is older then
current date email the user. This information is all on one sheet.
--
James


"Mike H" wrote:

Hi,

Have a look at the excellent resource


http://www.rondebruin.nl/mail/templates.htm

Mike

"JamesW" wrote:

We have a user who currently uses a simple spreadsheet to list certain types
of enquiries they get. They would like to set up a macro, or such, to enable
an automatic prompt, for example an email, to be sent to a member of staff if
something hasnt been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.

--
James

Automating Task within Excel To Send Emails
 

hi James

See the second example on this page
http://www.rondebruin.nl/mail/folder3/message.htm

--

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


"JamesW" wrote in message ...
Thanks Mike,

However what we need to do is for the task\macro to look at a cell, with a
date in it, and then compare it to the current date and if it is older then
current date email the user. This information is all on one sheet.
--
James


"Mike H" wrote:

Hi,

Have a look at the excellent resource


http://www.rondebruin.nl/mail/templates.htm

Mike

"JamesW" wrote:

We have a user who currently uses a simple spreadsheet to list certain types
of enquiries they get. They would like to set up a macro, or such, to enable
an automatic prompt, for example an email, to be sent to a member of staff if
something hasnt been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.

--
James

Automating Task within Excel To Send Emails
 

Ron,

Many thanks for the example. I will give that a go.

Regards
--
James


"Ron de Bruin" wrote:

hi James

See the second example on this page
http://www.rondebruin.nl/mail/folder3/message.htm

--

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


"JamesW" wrote in message ...
Thanks Mike,

However what we need to do is for the task\macro to look at a cell, with a
date in it, and then compare it to the current date and if it is older then
current date email the user. This information is all on one sheet.
--
James


"Mike H" wrote:

Hi,

Have a look at the excellent resource


http://www.rondebruin.nl/mail/templates.htm

Mike

"JamesW" wrote:

We have a user who currently uses a simple spreadsheet to list certain types
of enquiries they get. They would like to set up a macro, or such, to enable
an automatic prompt, for example an email, to be sent to a member of staff if
something hasnt been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.

--
James