Attach a file that is open to an email

**Bobbbo** · 10-06-2016, 09:54 PM

I have a macro that has the user browse for a file which I name "ManualForm" I do some edits to that file then I want to save it and email it as an attachment to an email. Here is the browsing code:

Please Login or Register  to view this content.

Then after my edits I use this code to attach it as an email but it fails, where "Cover" is another open workbook that contain information on where to: and cc: send the email.

Please Login or Register  to view this content.

Any idea why it will not attach the file?

**protonLeah** · 10-06-2016, 11:35 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.