Hi,
Can anyone tell me if this is possible, and if so how can it be done?
I have an excel form which users (at work, same software versions) populate information like an application (drop downs, text fields etc) Once the form is complete I need to add in a macro to email it but the user wants to be able to add in 2 word attachments.
- Can they be uploaded to excel somehow? e.g. button "upload file" - I've seen images of this when searching but cannot get it to work
- Can the macro to email be changed so when you click the button it tells you to attach "File 1" and "File 2" then presents you with a draft email, To, Subject, body filled in with the Excel document already attached for the user to attach the 2 documents in the usual way?
any other solutions which will give the same result?
Bookmarks