Hi! I really need your help as I am a newbie and can't get the right code.
What I would like to achieve is to send all the files in a folder as attachment to a single recipient. BUT, it must be one email per attachment. So if I have 20 files in a folder, I would also have 20 emails. It varies depending on how many files the folder has.
The subject of each email must be the same with the file name which are entered in Column B.
Please assist me in coding this in VBA Macro.
Thank you!
Bookmarks