Delete emails in my inbox from a list of email addresses?

[cavedwella]

Hi
Heres my problem...

I have a list of 4000 customer email addresses in a spreadsheet, who I want
to send an "email-merge" to the list.
(I'm ok with doing this)

(This is where I'm stuck)
Then cross check against the 16000 customer emails in my inbox. (some
multiple emails from the same address) and remove the ones which have
recieved a merged email...

Currently my thoughts...
Are to export the inbox to Excel and check for a match...
Trouble is... what then?

Once I have identified a matched email address how do I remove it from the
inbox without a manual sort and delete one by one?

Any help you could give with this would be greatly appreciated...

Thanks
Cav

(I'm Currently using Outlook 2003)

 

[cavedwella]

Do you think I could use the Junk Email options to import the merge list to
the blocked senders?

Which would, in theory, move all emails from the merge recipient addresses to
the junk email folder...
I could then delete/export or move them to a different folder...

Then delete the merge addresses from the "blocked senders" list... Bingo!!!

I'll try this when I get into work tomorrow and let you know if it works...

 

[John Blessing]

Hi
Heres my problem...

I have a list of 4000 customer email addresses in a spreadsheet, who
I want to send an "email-merge" to the list.
(I'm ok with doing this)

(This is where I'm stuck)
Then cross check against the 16000 customer emails in my inbox. (some
multiple emails from the same address) and remove the ones which have
recieved a merged email...

Currently my thoughts...
Are to export the inbox to Excel and check for a match...
Trouble is... what then?

Once I have identified a matched email address how do I remove it
from the inbox without a manual sort and delete one by one?

Any help you could give with this would be greatly appreciated...

Thanks
Cav

(I'm Currently using Outlook 2003)

You will have to write some VBA code to do what you need.
--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software
http://www.room-booking-software.com - Schedule rooms & equipment
bookings http://www.lbetoolbox.com - De-Duplicates MS Outlook
http://www.repeatmail.com - schedule mass individual emails

 

[cavedwella]

Do you think my Junk mail route is doomed to failure then?

I'm a bit of a newbie with VBA... any tips?

Hi
Heres my problem...

[quoted text clipped - 21 lines]

(I'm Currently using Outlook 2003)

You will have to write some VBA code to do what you need.

 

[Roady [MVP]]

Yes, as you have already received those messages. You might have some
success when you can re-receive those messages again in a clean mailbox.

For coding instruction see;
http://www.outlookcode.com



-----

Do you think my Junk mail route is doomed to failure then?

I'm a bit of a newbie with VBA... any tips?

Hi
Heres my problem...

[quoted text clipped - 21 lines]

(I'm Currently using Outlook 2003)

You will have to write some VBA code to do what you need.

 

[Roady [MVP]]

It's unclear to me why you want to delete those emails from the Inbox which
received a reply via a mail merge.

If all you want to do is filtering the contacts for another mail merge, then
you might be better off doing that in Excel.

Another option would be to "grab" all the addresses first and filter that
out via a specialized tool such as;
http://addins.howto-outlook.com/dsd_emailaddresscollector

If you decide to order use BF453F39 to get a discount.

 

[cavedwella]

Of course... doh.... the junk filter only works incoming mail... not once
it's in...
how about a rule? can I set a rule to do the same thing?

Sorry for not being clear about my intentions...

I have a list of customers who have ordered stock which will now not turn up
as the suppliers have gone belly up...
So I want to run a mail merge from all the orders to advise of the refund etc.
..

However the customer service team have recieved chase emails from some of
these customers...
Some more than once...

So after the mail merge I want to remove all the chase emails from the inbox
as "dealt with"...

Thanks

It's unclear to me why you want to delete those emails from the Inbox which
received a reply via a mail merge.

If all you want to do is filtering the contacts for another mail merge, then
you might be better off doing that in Excel.

Another option would be to "grab" all the addresses first and filter that
out via a specialized tool such as;
http://addins.howto-outlook.com/dsd_emailaddresscollector

If you decide to order use BF453F39 to get a discount.

Hi
Heres my problem...

[quoted text clipped - 22 lines]

(I'm Currently using Outlook 2003)

 

[Roady [MVP]]

A rule might be highly ineffective if you can only base it on the email
addresses; you would need to type them all in the rule first. With 4000
addresses, you are very likely to meet some rule limits as well. In that
case it is better to use some custom VBA and cross-reference it to your list
of mail merge addresses.

A rule would be great if you could find those messages based on something
else like a keyword or something. Then you can create a rule for that. It
might not be a 100% but something very close to that.

Another way would be to create an active link between Access and Outlook.
I'm not sure if Outlook/Access 2003 already had this functionality but in
Access 2007 you can have a 2-way sync between Outlook and Access. You can
then do a much more powerful query there which results directly reflects in
Outlook.

How did you determine the 4000 addresses to begin with? That might be of
help?



-----

Of course... doh.... the junk filter only works incoming mail... not once
it's in...
how about a rule? can I set a rule to do the same thing?

Sorry for not being clear about my intentions...

I have a list of customers who have ordered stock which will now not turn
up
as the suppliers have gone belly up...
So I want to run a mail merge from all the orders to advise of the refund
etc.
.

However the customer service team have recieved chase emails from some of
these customers...
Some more than once...

So after the mail merge I want to remove all the chase emails from the
inbox
as "dealt with"...

Thanks

It's unclear to me why you want to delete those emails from the Inbox
which
received a reply via a mail merge.

If all you want to do is filtering the contacts for another mail merge,
then
you might be better off doing that in Excel.

Another option would be to "grab" all the addresses first and filter that
out via a specialized tool such as;
http://addins.howto-outlook.com/dsd_emailaddresscollector

If you decide to order use BF453F39 to get a discount.

Hi
Heres my problem...

[quoted text clipped - 22 lines]

(I'm Currently using Outlook 2003)

 

[cavedwella via OfficeKB.com]

Thankyou for your time on this, however my boss has over ruled me and thown
manpower at it...
We have 6 people on the case going through the inbox deleting one at a time...

Barmy if you ask me but who am I to argue!!

Thanks Again..

A rule might be highly ineffective if you can only base it on the email
addresses; you would need to type them all in the rule first. With 4000
addresses, you are very likely to meet some rule limits as well. In that
case it is better to use some custom VBA and cross-reference it to your list
of mail merge addresses.

A rule would be great if you could find those messages based on something
else like a keyword or something. Then you can create a rule for that. It
might not be a 100% but something very close to that.

Another way would be to create an active link between Access and Outlook.
I'm not sure if Outlook/Access 2003 already had this functionality but in
Access 2007 you can have a 2-way sync between Outlook and Access. You can
then do a much more powerful query there which results directly reflects in
Outlook.

How did you determine the 4000 addresses to begin with? That might be of
help?

Of course... doh.... the junk filter only works incoming mail... not once
it's in...

[quoted text clipped - 38 lines]

 

[Roady [MVP]]

Ouch! Hope you're done before Christmas starts ;-)



-----

Thankyou for your time on this, however my boss has over ruled me and
thown
manpower at it...
We have 6 people on the case going through the inbox deleting one at a
time...

Barmy if you ask me but who am I to argue!!

Thanks Again..

A rule might be highly ineffective if you can only base it on the email
addresses; you would need to type them all in the rule first. With 4000
addresses, you are very likely to meet some rule limits as well. In that
case it is better to use some custom VBA and cross-reference it to your
list
of mail merge addresses.

A rule would be great if you could find those messages based on something
else like a keyword or something. Then you can create a rule for that. It
might not be a 100% but something very close to that.

Another way would be to create an active link between Access and Outlook.
I'm not sure if Outlook/Access 2003 already had this functionality but in
Access 2007 you can have a 2-way sync between Outlook and Access. You can
then do a much more powerful query there which results directly reflects
in
Outlook.

How did you determine the 4000 addresses to begin with? That might be of
help?

Of course... doh.... the junk filter only works incoming mail... not
once
it's in...

[quoted text clipped - 38 lines]

(I'm Currently using Outlook 2003)