Line up Text in Outlook (VBA E-mail)

[RandyKelly19]

I'm sending an e-mail of formatted text in a column to Outlook. I lined up the text in Outlook using a Rand() function, but it's not aligned in outlook.

The field contains Name, ID, and ticket #
I would like them to be lined up in outlook to be easily readable.

Any Suggestions?

 

[pbornemeier]

If you use a fixed width font (such as Courier New) you can line up columns by adding the appropriate number of spaces to breaks between columns on each line. Outlook also can use tabs which would allow the use of variable width fonts.
You could embed a portion of the Excel workboook in the email. This would look just as it does in Excel.

 

[RandyKelly19]

thanks for your reply. I am using Courier font in Excel and in lines up nicely. I didn't think to check the font being used in Outlook, but if that's the issue I need to be able to specify the font used in the new e-mail, because this will be used on multiple PC's.

The Tab Feature is that VBA? so that you can tab text over in to line up in Outlook?

I will look into that today. If anyone has any other ideas or ways to get text aligned in outlook please let me know


thanks again,
Randy

 

[pbornemeier]

Lots of info about sending email from Excel can be found here:
http://www.rondebruin.nl/sendmail.htm

Quite a bit of other nifty stuff on his website too.