I want to create an outlook template that would be an email that send a lot, but everytime there is like five things that are different then the prevouis email, that is the email address, the receivers name, the order number and two more. until now have been going to my outbox looked up the last email sent just changed these 5 feilds mannually and sent it. what could do is to create an outllok template that would have the whole email written just these 5 feilds should stay empty ready o filled up, but still this doesn't help to much when I want to send 20 such emails at once. what want to do is, to have an excel sheet filled with all the info that has to be filled into the template and outlook should generate te eamils from the ifo in his excel sheet
i use outlook 2010
it is a template that i created myself.
i used outlook to create it. I have no idea how to test with an excel file, that's my question!
I started working on it yesterday, everything worked, just one thing didn't work. Hyperlinks i couldn't transfer from excel. I found in microsoft support website, the exact same question that i have, but the problem is that it only answers how to do that in office 2003, not for 2010. would you be able to help me with office 2010?
Here is the link to microsofts website