Link to home
Start Free TrialLog in
Avatar of celtician
celticianFlag for American Samoa

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?

User generated image
Avatar of Christopher Jay Wolff
Christopher Jay Wolff
Flag of United States of America image

Many would use VBA, yet I like the hyperlink for this because I cannot run VBA on my Surface RT.

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:

=hyperlink(ʺmailto:Mgmnt@Shiftswappers.com?cc=ʺ&C6&ʺ&subject=Shift%20Swap%20Notice.&body=ʺ&B2&C2&ʺ%0Dʺ&B3&C3&ʺ%0D%0Dʺ&B5&C5&ʺ%0Dʺ&B7&C7&ʺʺ,ʺSend to Mgmnt@Shiftswappers.comʺ)

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.
Avatar of celtician

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.
Avatar of Rob Henson
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
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.
User generated image
Help doc on using email template here.
User generated image
And the field codes if you have to go that far are attached.
OutlookFormulaFieldCodeHelp.pdf
ASKER CERTIFIED SOLUTION
Avatar of Christopher Jay Wolff
Christopher Jay Wolff
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial