Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-12-2017, 07:32 AM
alejorubi alejorubi is offline Send and Email depending on cell with information Windows 8 Send and Email depending on cell with information Office 2010 32bit
Novice
Send and Email depending on cell with information
 
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 offline Send and Email depending on cell with information Windows 7 64bit Send and Email depending on cell with information Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
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
Send and Email depending on cell with information 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft