Emailing Attachments

[wmtsub]

Currently i am manually updating my email code evertyime I cahnge the attached files I am needing to send.
So i was wondering, hoc can i attache all files in a folder automatically to an email?

Line 1 is an example of teh attachement code, lin two is what ai was thinkiong of but does not work...

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif].Attachments.Add "\\JAent\TS\Email Attachments\VENDOR\Legal Entity.pdf"

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][LEFT][COLOR=#222222][FONT=Verdana].Attachments.Add "\\JAent\TS\Email Attachments\VENDOR\*.*"[/FONT][/COLOR][/LEFT][/FONT][B][I][U][SUB][SUP]<strike>
</strike>[/SUP][/SUB][/U][/I][/B][/FONT]

 

[Joe4]

You need to loop through the folder and attach email file separately.
There are some old posts on the topic that you can find with a Google search.
Here is one: https://www.mrexcel.com/forum/excel-questions/415954-attaching-multiple-files-email-document.html

 

[wmtsub]

Tks. Will review