Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 09-12-2017, 07:32 AM
alejorubi alejorubi is offline Windows 8 Office 2010 32bit
Join Date: Jul 2017
Posts: 1
alejorubi is on a distinguished road
Default 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

Reply With Quote
Old 09-12-2017, 08:13 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,090
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice

Hi and welcome
this kind of question has already been asked many times.
Googling a bit will certainly get you an answer
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Reply With Quote

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

All times are GMT -7. The time now is 04:09 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft