DataBlake
Well-known Member
- Joined
- Jan 26, 2015
- Messages
- 781
- Office Version
- 2016
- Platform
- Windows
Hey i'm having trouble getting an outlook code to work in my favor.
Basically i have a userform that an end user fills out and it assigns 2 strings to errorHD and issueHD
I want to check if the user already has outlook open
If its not then open outlook
Then use a template that looks like
Name & Date would be automatically generated using Application.Username and Now()
issueHD would be inserted under "Issue:"
errorHD would be inserted under "Error Codes:"
and this email would be automatically sent to me
i have a template made already "C:\dest\HelpDesk.oft"
just unsure of how to insert the text into it / what the best methods are to use here.
any help would be appreciated
Basically i have a userform that an end user fills out and it assigns 2 strings to errorHD and issueHD
I want to check if the user already has outlook open
If its not then open outlook
Then use a template that looks like
HTML:
Name & Date:
<p> TEXT TO BE INSERTED BY EXCEL
<p>
<p>
Issue:
<p> TEXT TO BE INSERTED BY EXCEL
<p>
<p>
Error Codes:
<p> TEXT TO BE INSERTED BY EXCEL
<p>
<p>
Name & Date would be automatically generated using Application.Username and Now()
issueHD would be inserted under "Issue:"
errorHD would be inserted under "Error Codes:"
and this email would be automatically sent to me
i have a template made already "C:\dest\HelpDesk.oft"
just unsure of how to insert the text into it / what the best methods are to use here.
any help would be appreciated