Rename attachment in draft email

gmayor · #1 01-30-2023, 06:02 AM

Normally signature images are in the format "image001.jpg" which the line

Code:

If Not sName Like "image*.jpg" Then

should omit. If your images are in a different format then you can use a similar statement to omit those, or if your attachments are in a particular format e.g. *.docx or *.xlsx then you could change the line to (say)

Code:

If sName Like "*.docx" Or sName Like "*.xlsx" Then

or whatever fits your requirements to process just those attachment formats.

JamesMWood · #2 01-30-2023, 06:53 AM

Quote:

Originally Posted by gmayor

Normally signature images are in the format "image001.jpg" which the line

Code:

If Not sName Like "image*.jpg" Then

should omit. If your images are in a different format then you can use a similar statement to omit those, or if your attachments are in a particular format e.g. *.docx or *.xlsx then you could change the line to (say)

Code:

If sName Like "*.docx" Or sName Like "*.xlsx" Then

or whatever fits your requirements to process just those attachment formats.

Ahhh I understand, I'll give that a shot. Thanks very much, you are really generous with your time and knowledge, it's appreciated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rename attachment based on attachment name	AndyDDUK	Outlook	1	03-01-2017 07:32 AM
Rename attachment based on attachment name	AndyDDUK	Outlook	1	03-01-2017 07:31 AM
Rename docm to value from checkbox, convert to .pdf, email, delete	Lortiz70	Word VBA	1	01-19-2017 02:48 AM
Email sends mailmerge file behind email rather than attachment	TLC1974	Mail Merge	2	07-22-2016 12:53 AM
email as pdf attachment - subject line and attachment named after mail merge	Nexus	Mail Merge	12	04-13-2011 11:34 PM