How to Automatically Send Emails from Excel Based on Cell Content

**24jason** · 03-18-2014, 10:31 AM

i am looking to send order confirmations to my clients via email based on data I type into my master worksheet.

i will type in all orders we receive on day 1, from all different clients (A, B and C) with the relevant details to confirm the order.

i want a method to send email so that each client receives his own individual confirmation from my master worksheet.

is this possible? please advise.

thanks for your help.

**mrice** · 03-18-2014, 03:00 PM

If you are using Outlook as your e-mail client, you can do this.

Have a look at

http://www.rondebruin.nl/win/s1/outlook/mail.htm

to get started.

**jai koshal** · 12-19-2014, 11:28 AM

I am looking for Macro for excel 2007 to send emails which Send a mail when a cell reaches a certain value
That i want to use if my cell A1 valve reaches equal to cell N4 value then its auto generate mail and sent it to following address in cell P2.
The value in cell A1 is getting from a formula i.e (B1+C1-D1).
Please help me to make it so that i can continues study in this system.

Thanks in advance