Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 08:41 AM.


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