Before send criteria

Not open for further replies.

VBA Noob

Outlook version
Email Account
Exchange Server
Hi people,

I'm looking for a way to check before sending if an email has the word "attached" and if there is an attachment make sure it's an .xls extension. I found some code which kind of does this but it's only looking at general attachments and counts the auto signature.

VBA Noob
So basically, you want to check for attachment keywords then check the attachments to see if any have xls extensions?
Correct. Should check for the key word in subject title and boby of text then check file extension is an excel format I guess either .xls or .xlsx

VBA Noob
I'm not sure you can merge the macros - i'll have to take a look at them in the morning. (plus i asked some outlook developers for assistance - hopefully they will have a code sample.)
Hi Slipstick,

I think this works for me. I've managed to work out my Auto signature has a .png and .jpg attachement so use the below to work out how many of these items I've got e.g 2 and deduct from the

If item.Attachments.Count > 0 Then
   For i = 1 To item.Attachments.Count
       If item.Attachments(i).FileName Like "*PNG*" Or item.Attachments(i).FileName Like "*JPG*" Then
               Cnt = Cnt + 1
       End If
   Next i

VBA Noob
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
PGSystemTester VBA To Change AppointmentItem.BusyStatus From MeetingItem Before Send Using Outlook 0
L check if send message appears in SendItems forder before moving Using Outlook 0
R unable to filter tasks when start date is on or before today Using Outlook 3
L However, before you place an order, you want to pick out whether or not you want the to Using Outlook 0
Timmon Remove just one attachment before AutoForward Outlook VBA and Custom Forms 0
e_a_g_l_e_p_i A few question before I decide to switch to Pop from imap Using Outlook 9
U Disable "Always ask before opening" Dialog Using Outlook 3
L isn't there an OL add-on that flags addressee before sending Using Outlook 3
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
L unblocking attachments before sending Office 365 Advanced Protection Using Outlook 0
R Warn before sending message Outlook VBA and Custom Forms 4
W Outlook 2010 some sent items marked unread now (was Ok before) Using Outlook 0
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1
M Moving mail to another folder is much slower than before (Office365) Using Outlook 0
A Check for words in subject header before sending email Outlook VBA and Custom Forms 4
CWM030 Rules disappearing in OL 2016? ( Yes, I searched before posting) Using Outlook 7
U Outlook 2010 'freezes' before moving emails Using Outlook 2
S Mail filter recieved before the last 2 working days Using Outlook 1
copperberry How to display incomplete tasks due on or before 7 days from now Using Outlook 0
O Rules and Alerts for New Messages BEFORE sending Using Outlook 2
G Can't open .pst. Message could not access default folder (Outlook 2010 (.pst). Before that was backi Using Outlook 0
Diane Poremsky Select from a List of Subjects before Sending a Message Using Outlook 0
Diane Poremsky Check Contacts before moving them to Hotmail Contacts folder Using Outlook 0
Diane Poremsky Check for missing attachments before sending a message Using Outlook 1
Diane Poremsky Warn before sending messages to the wrong email address Using Outlook 1
J How to validate any email address before it is sent Using Outlook 2
K Problem with FreeBusy (before 1pm only) Outlook VBA and Custom Forms 7
Diane Poremsky Add Attachment Names to Message Before Sending Using Outlook 0
Diane Poremsky Check Message Size Before Sending Using Outlook 0
Diane Poremsky Add Secure to the Message Subject before Sending Using Outlook 0
J Creating a URL from a message body excerpt before forwarding Using Outlook 2
F Recurring meeting with recurring prep. 2 days before Using Outlook 1
S Checking attachment is passward protected or not before sending the mail Using Outlook 1
D how to get inbox messages to appear before deleted file messages? Using Outlook 6
D verify contact before sending Using Outlook 7
N Eliminate the +1 before all numbers Using Outlook 1
C Is there a way to prompt a user before deleting an item? BCM (Business Contact Manager) 4
S Outlook to validate task form before sending Using Outlook 5
S Prompt to add for text to existing subject line before sending. Using Outlook 9
N Outlook should use address in address book before the address in Autocomplete Using Outlook 0
S Trying to have a prompt to ask for text to be added to subject before sending. Using Outlook 3
H Insert Specific Text before Subject for New mails and reply Using Outlook 3
R What to backup before removing Outlook 2010? Using Outlook 4
T Is there a way to apply a macro before a signature is applied in email? Using Outlook 1
B How do I get a warning before deleting e-mail messages? Using Outlook 2
R Outlook 2003 - Close parent form before opening child form Outlook VBA and Custom Forms 4
B Confirm before sending? Using Outlook 7
K How to prevent that Outlook is sending before my add-in is finished? Outlook VBA and Custom Forms 5
G Confirm Each Recipient in a New Outlook Mail Before it is Sent Outlook VBA and Custom Forms 4

Similar threads