Hi!

Ok so I have searched high and low for this but cannot seem to find anything that solves all of my problems in one go. I hope someone here will hear my cry for help!

This is my situation;

I have a master Excel file with lots of different functuality that Iīm very proud of. My last issue to solve is to send some files to an e-mailadress.
The files are created by a macro and named accroding to a combination created by values in the master file. The names will vary between each time the master file is used. The files are copies, with values, of hidden sheets within the master file. The sheets will be visible in the master file as they are saved in the folder so one could perhaps save them temporary somewhere... The number of files can range from 1 up to 16 and are saved in the same location as where ever the master file is located. I want to grab those files, however many they are, attach them to an e-mail (outlook) and send them to an e-mailaddress specified in a cell in the master file.

I have sucessfully been using Ron de Bruinīs e-mail macros before, so amazing, but I cannot seem to modify them accroding to my needs above.

I would really appreciate anyones help with this!

Many thanks in advance!