<div>
<div class="content wysiwyg-content">
Hi, 
 
I am sending an e-mail though outlook by using VBA. However the formatting is not very good. I know I can use HTML to help format the text. 
 
I wanted to know if it was possible to create a html table as I have 5 fields. Each field can contain strings of different lengths so at the moment it doesn't look very nice. Please see below an example. The first line is the headers the other rows are the actual data. What is the best way to display/format this data? 
 

<blockquote>
 
ISIN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Security &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Field &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Old Value &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New Value 
 
 
 
CA135087YF56 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CANADIAN GOVT 4% 01/06/17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Moody LT Issue Rating &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Aaa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
 
CA135087YF56 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CANADIAN GOVT 4% 01/06/17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SandP LT Issue Rating &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AAA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CCC+ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
 
AT0000383864 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AUSTRIAN GOVERNMENT 6.25% 15/07/27 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Moody LT Issue Rating &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Aaa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CCC+ &nbsp; 
 
 

</blockquote>
 
Thanks, 
 
M
</div>
</div>

Hi,

I am sending an e-mail though outlook by using VBA. However the formatting is not very good. I know I can use HTML to help format the text.

I wanted to know if it was possible to create a html table as I have 5 fields. Each field can contain strings of different lengths so at the moment it doesn't look very nice. Please see below an example. The first line is the headers the other rows are the actual data. What is the best way to display/format this data?


ISIN            Security                Field           Old Value               New Value 



CA135087YF56            CANADIAN GOVT 4% 01/06/17               Moody LT Issue Rating           Aaa             B3              

CA135087YF56            CANADIAN GOVT 4% 01/06/17               SandP LT Issue Rating           AAA             CCC+            

AT0000383864            AUSTRIAN GOVERNMENT 6.25% 15/07/27              Moody LT Issue Rating           Aaa             CCC+   




Thanks,

M

VBA Outlook Email HTMLBody

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.