Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-12-2017, 07:32 AM
alejorubi alejorubi is offline Windows 8 Office 2010 32bit
Novice
 
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

AR
Reply With Quote
  #2  
Old 09-12-2017, 08:13 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,940
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Hi and welcome
this kind of question has already been asked many times.
Googling a bit will certainly get you an answer
Reply With Quote
Reply

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 10:49 AM.


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