Macro to move @domain.xx of a Spammail to Blacklist in Outlook 2019

witzker

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Hi

I have to move from OL 2010 to 2019
Now its also time to take care of increasing Spam I get.

As OL can normally only add the whole email address to blacklist it would be great to have a macro in the ribbon that does the sane as
Block sender, but not only move xxx@dmain.xx but @domain.xx instead.

Maybe there is something still existing, what can be changed that way?

Pls help

regards
Witzker
 

witzker

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
But you can always go in and edit the blocked list to remove the alias.

OK but I think I did something wrong with my websites, so I'm drowning in Spam.
I need to do it with a macro otherwise it will take too much time.

THX for taking care!
 

witzker

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Therefore, I need help with the macro

How to Get the domain of an email in Blacklist as described above
 

witzker

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
I'll need to look at it, I'm not sure what is exposed in the object model. But you can always go in and edit the blocked list to remove the alias

Any news?

More explanation of the Problem:

I get Spam mails in Inbox.
Then right-click on the mail
1606165007697.png

Absender sperren = Block Sender

This mail address should Go to Blacklist!?
1606165389283.png


1606165604843.png



I now look for a macro (BlcklistDomain)that inserts only the domain in this list
@grollmus.com
That all mails from the same Domain are blocked!!

This exists other way round with whitelist

1606165927106.png

Domain des Absenders nie sperren = never block this domain

1606165805641.png


Conlusion

When in Inbox standing on a Mail and clicking the desired macro(BlacklistDomain) the domain of this mail is put in blacklist.
I hope you understand what i mean.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You need to use Redemption.
Strings object (dimastr.com)


This sample saves the domain of the selected message to the safe list - you won't see it in the junk email list until you restart outlook though.

Code:
Sub writetojunk()

 Dim objApp As Outlook.Application
 Dim objMail As MailItem
 Dim strDomain As String
 
 Set objApp = Application
 Set objMail = objApp.ActiveExplorer.Selection.Item(1)
   strDomain = Right(objMail.SenderEmailAddress, Len(objMail.SenderEmailAddress) - InStr(objMail.SenderEmailAddress, "@") + 1)
  Debug.Print strDomain

 Set rSession = CreateObject("Redemption.RDOSession")
  rSession.MAPIOBJECT = Application.Session.MAPIOBJECT
  Set JunkOptions = rSession.JunkEmailOptions
  JunkOptions.TrustedSenders.Add strDomain
  JunkOptions.Save

MsgBox strDomain & " added to Safe list"

End Sub
 

witzker

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
selected message to the safe list
THX
I think I posted the wrong picture!! Sorry!
When in Inbox standing on a Mail and clicking the desired macro(BlacklistDomain) the domain of this mail is put in blacklist.

PLS. I want to add the senders' domain to
Blacklist!
1606529731054.png


And put the mail in Junk Folder

can you assist pls.
 
Similar threads
Thread starter Title Forum Replies Date
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
Eike Move mails via macro triggered by the click of a button? Outlook VBA and Custom Forms 0
N Macro to move all recipients to CC while replying Outlook VBA and Custom Forms 0
B Macro to manually move selected emails to network folder Outlook VBA and Custom Forms 1
G email returns after running macro to move emails Outlook VBA and Custom Forms 1
Douglas Littlefield Macro to move E-mail Outlook VBA and Custom Forms 10
S Macro to print & move selected emails? Using Outlook 3
Douglas Littlefield Macro to move mail from inbox to Managed Folder Exchange Server Administration 1
L Macro Move E-mail attachments to a PC Folder Using Outlook 16
G Macro to move sent items from local folder to IMAP folder Using Outlook 4
S Outlook macro to move replied / forwarded emails to a seperate folder Using Outlook 1
C Help with a Macro to move emails to a different PST data file Using Outlook 4
J Macro to move mail from Inbox if older than 4 days Using Outlook 4
witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
S Macro or plug-in to see if specific person was included in this email Outlook VBA and Custom Forms 4
U Macro for reminders,tasks,calendar Outlook VBA and Custom Forms 4
V macro runs slower on startup than after Outlook VBA and Custom Forms 3
A VBA macro for 15 second loop in send and received just for 1 specific mailbox Outlook VBA and Custom Forms 1
G VBA Macro Calendar Printing Assistant 4
R Help Revising VBA macro to delete email over different time span Outlook VBA and Custom Forms 0
M Outlook macro to automate search and forward process Outlook VBA and Custom Forms 6
R Macro Schedule every day in Outlook Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
Healy Consultants Macro to remove inside organization distribution list email address when reply to all recepients Outlook VBA and Custom Forms 0
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
N How can I increase/faster outlook VBA Macro Speed ? Using Outlook 2
4 Macro to set the category of Deleted Item? Outlook VBA and Custom Forms 2
D.Moore Folder view settings by VBA macro Outlook VBA and Custom Forms 57
A Outlook macro to create search folder with mail categories as criteria Outlook VBA and Custom Forms 3
Dave A Run macro on existing appointment when it changes Outlook VBA and Custom Forms 1
V Outlook Macro to show Flagged messages Outlook VBA and Custom Forms 2
O Run macro automatically at sending an email Using Outlook 11
R Retain Original Message When Forwarding With Macro Outlook VBA and Custom Forms 3
C Macro to add multiple recipients to message Outlook VBA and Custom Forms 3
B Reply and replyall macro is not working Outlook VBA and Custom Forms 1
O Macro - paste as plain text Outlook VBA and Custom Forms 2
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
witzker Macro to set contact reminder to next day 9:00 Outlook VBA and Custom Forms 45
M Adding Macro to populate "to" "subject" "body" not deleting email string below. Outlook VBA and Custom Forms 5
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
R VBA macro - new message Outlook VBA and Custom Forms 3
S Example VBA Macro - To Conditionally Change the From Account and Add a BCC Address on Emails Outlook VBA and Custom Forms 11
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
S VBA Macro - Run-time error '424': object required - Help Please Outlook VBA and Custom Forms 3

Similar threads

Top