I have a functional and working Robot which sends mails to recepients from an excel sheet.
The robot reads a word file, looks for certain values to replace in the text with values from the excel sheet, individuial to each person and finally sends the mail.
I use Excel Appl scope, Word Appl. scope, for each row and Send Outlook mail message.
My problem is that the text in the mail seems to change a lot in format from the actual word text (line distance and hyperlinks won’t work).
At first I thought I could fix it by ticking off IsBodyHtml int he mail message properties, but this makes it even even worse.
Can anyone point me in the right direction?