Hi,
I need help with a solution to to send an email with attachments
I have a "Send Email" button (can't work out how to change current send email macro to solve my issue) linked to a macro which sends the current workbook (with a couple of validations) to a predetermined email address with a set subject and body.
I would like to be able to do 2 things
- send the email with the current workbook PLUS 2 word documents
- make a space within the workbook for the file names of the 2 word documents. - ideally an "upload file" type field where the user can select the file they want to "attach"
if this isn't possible, is there a way you can have a "send email" function which pops up a message asking them to attach the 2 files and then presents an email draft with the workbook, send to email, subject and body pre-populated?
I need help with a solution to to send an email with attachments
I have a "Send Email" button (can't work out how to change current send email macro to solve my issue) linked to a macro which sends the current workbook (with a couple of validations) to a predetermined email address with a set subject and body.
I would like to be able to do 2 things
- send the email with the current workbook PLUS 2 word documents
- make a space within the workbook for the file names of the 2 word documents. - ideally an "upload file" type field where the user can select the file they want to "attach"
if this isn't possible, is there a way you can have a "send email" function which pops up a message asking them to attach the 2 files and then presents an email draft with the workbook, send to email, subject and body pre-populated?
