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 item.Attachments.Count
If item.Attachments.Count > 0 Then
For i = 1 To...
I've found this link but having trouble getting it working with the before send code
Any help or suggestions welcome
http://www.gregthatcher.org/Scripts/VBA/Outlook/GetEmailAttachments.aspx
The before send code is from here...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.