celtician
asked on
Create email template using microsoft office
Everyday we send some report, we use a microsoft word template, and after completing some fields in the template, we send it via email using the next button (see capture below), and adding manually the recipients and writing also manually the subject
is there any way to change or convert this template and include the email subject and the recipients so i only have to fill the report and send it??
what can i do?
is there any way to change or convert this template and include the email subject and the recipients so i only have to fill the report and send it??
what can i do?
ASKER
Id rather use word than excel.
I understand the email hyperlink concept, however id rather create some sort of email template with all the info, as what im sending actually is an email and not a word document.
I understand the email hyperlink concept, however id rather create some sort of email template with all the info, as what im sending actually is an email and not a word document.
How about the MS Word "Mail Merge" feature?
Eventhough you create a Word document as such, it will be distributed as an email when you choose the email option.
Thanks
Rob H
Eventhough you create a Word document as such, it will be distributed as an email when you choose the email option.
Thanks
Rob H
ASKER
Ill take a look into that option.
Hi again.
Looked into Word 2013. Nice options for forms with control objects, but doesn't translate to email very good. Even with the mailto command being used to fill in the fields of To, From, BCC, CC, Subject, Body. Couldn't get attachment part of mailto command to function. Then I could look into embedding an excel sheet into word but it is not efficient.
Your best option is probably to use your email client. I have Outlook 2013 and it has forms and formulae for field codes etc if you need that level of stuff.
File, Options, Customize Ribbon, on right column check the box for turning on your Developer tab, OK.
Now open new message and click Developer tab, then click design a form.
Here's a link with some more on making the form.
http://www.avirtualexit.com/2012/08/make-user-forms-outlook-2013/
You could also look into using field codes and formula if you need them. Can be useful if you enter one piece of data and it affects new sums or percentages elsewhere on the form.
Help doc on creating email template in Outlook here.
Help doc on using email template here.
And the field codes if you have to go that far are attached.
OutlookFormulaFieldCodeHelp.pdf
Looked into Word 2013. Nice options for forms with control objects, but doesn't translate to email very good. Even with the mailto command being used to fill in the fields of To, From, BCC, CC, Subject, Body. Couldn't get attachment part of mailto command to function. Then I could look into embedding an excel sheet into word but it is not efficient.
Your best option is probably to use your email client. I have Outlook 2013 and it has forms and formulae for field codes etc if you need that level of stuff.
File, Options, Customize Ribbon, on right column check the box for turning on your Developer tab, OK.
Now open new message and click Developer tab, then click design a form.
Here's a link with some more on making the form.
http://www.avirtualexit.com/2012/08/make-user-forms-outlook-2013/
You could also look into using field codes and formula if you need them. Can be useful if you enter one piece of data and it affects new sums or percentages elsewhere on the form.
Help doc on creating email template in Outlook here.
Help doc on using email template here.
And the field codes if you have to go that far are attached.
OutlookFormulaFieldCodeHelp.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you're filling in fields in your Word template it sounds like you're using a table in Word. True?
This might be a little easier in Excel where I did a similar email. The user changes the data in each cell on the spreadsheet that needs updating. In your case, the user would not be able to change the To, and Subject unless you want that. Then the user clicks the hyperlink to email the data. In my case, my default is Outlook 2013 and the hyperlink launches Outlook, fills in the To, From, CC, Subject, Body, etc. and I just click send. The body would be from the text entered into one of your cells in the spreadsheet.
As an example, I did it in Excel and then put it on Google Sheets. My syntax for my hyperlink is:
Open in new window
You can see it here.
https://docs.google.com/spreadsheets/d/1BF45fVlvNWUDwaohH62BV_4IWlVjBiNe0nqrA2VQuKw/edit#gid=1330140928
If you're interested in Word, I'd have to look into it tomorrow. It may be just fine. Word emails from hyperlinks, but I've never done it so would want to verify how it would work for you. Maybe it is the same except you would have the doc for the body or something. And you wanted to hard code the To, From, Subject anyway, so they wouldn't need to be in a spreadsheet. In my 2013 I can also insert an Excel spreadsheet into my Word doc.