Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2016, 07:58 AM
ianhaney ianhaney is offline prevent email from being sent to specific email address Windows 10 prevent email from being sent to specific email address Office 2010 64bit
Banned
prevent email from being sent to specific email address
 
Join Date: Jul 2016
Posts: 3
ianhaney is on a distinguished road
Default prevent email from being sent to specific email address

Hi



I do a lot of email marketing and I was wondering if it is possible for outlook standard 2010 to prevent me from sending a email to a email address that I have already sent a email to so I don't send the same email to a email address that I have already sent the email to

hope that makes sense

Thank you in advance
Reply With Quote
  #2  
Old 07-18-2016, 10:01 PM
gmayor's Avatar
gmayor gmayor is offline prevent email from being sent to specific email address Windows 10 prevent email from being sent to specific email address Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If you mail merge to e-mail, then surely those that you have mailed to will be the addresses in the data source? Maybe http://www.gmayor.com/ManyToOne.htm will help with the merge (most likely in one to one mode)?

A second layer of protection would be to log the sent e-mails in an Excel worksheet as they are sent, using the Application_ItemSend event having performed a look-up from that list in the same macro to determine whether to send the message. Then you have to determine what to do with the unsent messages, in terms of logging and filing. It has the makings of a more major project than perhaps you envisaged.

Mail merge from a datasource of recipients would present a simpler solution.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 07-19-2016, 01:53 AM
ianhaney ianhaney is offline prevent email from being sent to specific email address Windows 10 prevent email from being sent to specific email address Office 2010 64bit
Banned
prevent email from being sent to specific email address
 
Join Date: Jul 2016
Posts: 3
ianhaney is on a distinguished road
Default

Hi

Thank you for the reply, appreciate it

seems mail merge to email is the best solution but how does it work, do I download it from the link you provided and then does it flag up if I have sent a email already to the email address so I don't end up sending the same email to a email address that I have already sent to?
Reply With Quote
  #4  
Old 07-19-2016, 04:31 AM
gmayor's Avatar
gmayor gmayor is offline prevent email from being sent to specific email address Windows 10 prevent email from being sent to specific email address Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The process simply facilitates the mail merge of a set of data stored in Excel to each record in the data source. If you merge the data source to e-mail you will have sent messages to all the names in your list.

Clearly therefore if you merge the same message with the same records again, you will have sent the messages twice. It does not otherwise record to whom you have sent the messages, beyond what is stored in your Sent messages folder.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 07-19-2016, 05:08 AM
ianhaney ianhaney is offline prevent email from being sent to specific email address Windows 10 prevent email from being sent to specific email address Office 2010 64bit
Banned
prevent email from being sent to specific email address
 
Join Date: Jul 2016
Posts: 3
ianhaney is on a distinguished road
Default

OK

sorry last question, I take it that if a email address appears in the to field of a new email when I start typing in the email address, I guess that means that a email has already been sent to that email address?

That right?
Reply With Quote
  #6  
Old 07-19-2016, 11:09 PM
gmayor's Avatar
gmayor gmayor is offline prevent email from being sent to specific email address Windows 10 prevent email from being sent to specific email address Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

In theory that should be the case, but it is possible to edit that list or delete items from it.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Email Address of Previous Email when Replying or Forwarding bondingfortoday Outlook 0 03-05-2016 04:29 PM
prevent email from being sent to specific email address email address suggestion while filling new email "to" and get rid of diacritics bernatikv Outlook 1 12-17-2015 10:51 PM
Mail Merge Many URLs in one email by common email address instantaphex Mail Merge 3 04-29-2013 05:46 PM
prevent email from being sent to specific email address Outlook won't reply/forward email from one email address rluna68 Outlook 2 01-07-2013 12:42 PM
prevent email from being sent to specific email address Outllok (2003) Rule to Send a New Email to a New Address upon Receipt of Specific Msg Hendel Outlook 1 10-27-2011 09:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 PM.


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