Email Dialog Box Selected Excel attachment

[ciaran01]

Hi All,

Im using the excel VBA below to trigger an email from a spreadsheet which conatins my email distribution list from column B and the subject etc from cell references on the same active worksheet. This code works great. However there are 2 additions I would like to make and have not managed to add:

1) I would like the macro to trigger a dialog box from which I can attach an xlsx file of my choice from a shared drive
2) I would then like the file name that I choose to be used to populate the email subject eg "file 1 12022014." Guessing this may have to happen before the email gets teed up which is fine.


If anyone can help I would very much appreciate it

Thanks in advance

Ciaran01

Please Login or Register  to view this content.

[john55]

try this, is different from yr code but you can select what you want,

Please Login or Register  to view this content.

[ciaran01]

This worked an absolute charm, thanks for your help John

[john55]

You're welcome!
Thanks for the rep 'n glad it helped you!
If you are happy with this solution, please mark the thread as "Solved". thx!