View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NS421 NS421 is offline
external usenet poster
 
Posts: 8
Default Send e-mail from a Excel file

I'd like to do something similar to this. I have a Contract database, that
tracks the Vendor, the Go Live Date and then calculates about 2 weeks out
when the contract should be sent out. What I'd like to be able to do is have
the spreadsheet send a reminder e-mail to the three people involved in the
Contract process once the 2 week date is hit.

I'm not very good at this.. I've only ever written one macro and that was
pretty much a copy and paste job from someone here. Any and all help would be
greatly appreciated!

N

"Ron de Bruin" wrote:

Start here
http://www.rondebruin.nl/mail/folder3/message.htm

If you need more help post back

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Freshman" wrote in message ...
Dear experts,

I've a database of clients' information. Column A is clients' names; column
B is account numbers; column C is subscription dates; column D is expiry
dates.

My question is, if I set a formula in column E which shows "Renewal" if
expiry date minus today is less than 30 days. Subsequently, if coulmn E
showed "Renewal", then a macro can trigger an action which can generate a
reminder e-mail to respective client in accordance with the e-mail address in
column F. In the reminder e-mail, it should contain respective client's name,
account name, the expiry date and some standard wordings. Can it be done? If
yes, please kindly advise.

Thanks in advance