Send e-mail from a Excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Freshman - 31 Oct 2006 10:23 GMT

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

Reply to this Message

Ron de Bruin - 31 Oct 2006 20:23 GMT

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

If you need more help post back

Signature

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

> Dear experts,
>
[quoted text clipped - 11 lines]
>
> Thanks in advance

Reply to this Message

Freshman - 01 Nov 2006 03:59 GMT

Dear Ron,

Thanks for your code and it suits my case. However, your code states that it
only works when use Excel Outlook. What about Lotus Notes? What lines in the
code need to be replaced? Please kindly advise.

Thanks a million. Regards.

> Start here
> http://www.rondebruin.nl/mail/folder3/message.htm
[quoted text clipped - 16 lines]
> >
> > Thanks in advance

Reply to this Message

Ron de Bruin - 01 Nov 2006 12:34 GMT

For Notes see
http://www.excelkb.com/?cNode=1X5M7A

Or see my CDO page
http://www.rondebruin.nl/cdo.htm

Signature

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

> Dear Ron,
>
[quoted text clipped - 24 lines]
>> >
>> > Thanks in advance

Reply to this Message

NS421 - 24 Mar 2008 17:05 GMT

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

> Start here
> http://www.rondebruin.nl/mail/folder3/message.htm
[quoted text clipped - 16 lines]
> >
> > Thanks in advance

Reply to this Message

Ron de Bruin - 24 Mar 2008 19:08 GMT

Have you look at example 2 on that page
There is a formla that looks at a date in that example

If you want to send the mail to more then one person tell me where the
mail addresses are in the database.
Or are they always the same

Signature

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

> 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
[quoted text clipped - 28 lines]
>> >
>> > Thanks in advance

Reply to this Message