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

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

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?

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

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?

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