Browse for a file edit the file then attach it to an email

**Bobbbo** · 10-06-2016, 10:01 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?

**humdingaling** · 10-06-2016, 10:04 PM

judging by your code it only represents the fill name

when you use attachments.add ....
manualform needs to represent the the full file system path with a file name

try adding the path and extension into the line and see if it works

**alansidman** · 10-06-2016, 11:50 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.