Hi
I am very new to VBA and need some help figuring this out. Greatly appreciate any help. I have searched and tried to change some solutions to my needs, but I’m coming up short…
Case:
By pressing a button, in Excel, the user of the workbook (there are several users), should open a new Outlook email with:
Sorry if this has been answered before, just could not find a solution that suits my needs. Thanks for any help
I am very new to VBA and need some help figuring this out. Greatly appreciate any help. I have searched and tried to change some solutions to my needs, but I’m coming up short…
Case:
By pressing a button, in Excel, the user of the workbook (there are several users), should open a new Outlook email with:
- Email sent on behalf of:
- If cell B42:
- States “A”, send from “#1” email account
- States “B”, send from “#2” email account
- States “C”, send from “#3” email account
- If cell B42:
- To: Value in cell B37
- Subject: “Fixed text” + value of cell B44
- Signature in HTML from the current user. The signatures of the users don’t have the same filename.
Sorry if this has been answered before, just could not find a solution that suits my needs. Thanks for any help