Recent content by VBA Noob

  1. V

    Before send criteria

    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...
  2. V

    Before send criteria

    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...
  3. V

    Before send criteria

    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
  4. V

    Before send criteria

    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
Back
Top