#1
|
|||
|
|||
Send and Email depending on cell with information
Hi everyone,
I have the following issue: I have to send our customers their tracking number once it has been generated so I have the following: Column A. Name of Customer Column B. Tracking number (when is inputted, blank if not) Column C. Email of the customer So, the idea is that when cell in column B is inputted the system sends and email as follows: Dear "Cell in Column A", Your document has been send with the tracking number "Cell in Column A" Kind regards, Customer Service Now. It has to be sent one time so, the next time I input another tracking number should not be repeated the previous one. Don't care if I have to use flags on other cells to stop Thanks in advance AR |
#2
|
||||
|
||||
Hi and welcome
this kind of question has already been asked many times. Googling a bit will certainly get you an answer
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
send Reminder Email to Outlook if cell value reaching before due date | sathishsusa | Excel Programming | 4 | 07-23-2017 01:38 PM |
Populating ranking depending upon ranges of previous cell's data | sryder | Excel | 5 | 04-07-2016 03:37 PM |
Creating AutoFill form - AutoFill information depending on a selection. | RyanHarper | Word | 3 | 06-15-2015 01:01 PM |
Outlook macro to check a value of a cell in an attachment and send an email based on that value | ketangarg86 | Outlook | 13 | 03-25-2015 07:11 AM |
Macro to export email to text file on send depending on category | Joe Patrick | Outlook | 0 | 10-19-2012 06:20 PM |