From what I have researched about Outlook's
templates and sending emails in the manner in that you wish to, you will first need to make the Template in Word
first, because that is where the Merge
function is. Since Outlook
is really only an Email program and uses Word
for it's word processing (what allows you to use different fonts, bold, paragraph formatting, etc.)
So what you'll need to do is build your template letter in Word
first, use the Merge
function to combine your Excel
document to utilize the information in there. In the Excel
file will need to be a Header/Label Row at the top of the sheet, this will make it easier to create and assign the fields in the Word
You can have as much unique information in the merge as you want to have in your spreadsheet as well.
If you have any questions please do not hesitate to ask for clarification.
Thank you for your patience and choosing this site of Experts to answer your question.