Rob_010101
Board Regular
- Joined
- Jul 24, 2017
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
Hello,
I've created a form in excel and added a button at the bottom.
I'd like to assign this button a macro that when it's pushed it:
1. Attaches the Excel as a PDF to a new email (the PDF can be named Maternity Leave Notification Form)
2. Looks at Cell E33 for the email address to send to and adds this into the "To" field of the email
3. Sets the subject line as "Maternity Leave Dates Notification Form"
4. Adds specific text into the body of the email.
I can specify this text if needed or can be told where to add it into the code myself.
Many thanks in advance,
Chris
I've created a form in excel and added a button at the bottom.
I'd like to assign this button a macro that when it's pushed it:
1. Attaches the Excel as a PDF to a new email (the PDF can be named Maternity Leave Notification Form)
2. Looks at Cell E33 for the email address to send to and adds this into the "To" field of the email
3. Sets the subject line as "Maternity Leave Dates Notification Form"
4. Adds specific text into the body of the email.
I can specify this text if needed or can be told where to add it into the code myself.
Many thanks in advance,
Chris