Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
outlook email body formatting issues from excel vba
Hi, my name's Kyle.
I'm sending email from Excel VBA for the first time. I've got everything working just fine and dandy - emails are going where I want them, with attachments when I want them, but the formatted text strings (multiple lines of dates, numbers, and text) that I want in the email body are getting screwed up. I need a fixed space font to get things lined up. First, when I was just using .body, the text was showing up in the resulting email in a proportional font. So, I figured out that .htmlbody was the way to go, but I'm flailing around - I've managed to specify a fixed space font, but the spaces are getting stripped out of my formatted text strings! Is there a way to prevent my spaces from getting stripped out? Can someone please help!? Kyle Lehigh Valley, PA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
outlook email body formatting issues from excel vba
On Jul 29, 10:28*pm, mr rapidan wrote:
Hi, my name's Kyle. I'm sending email from Excel VBA for the first time. *I've got everything working just fine and dandy - emails are going where I want them, with attachments when I want them, but the formatted text strings (multiple lines of dates, numbers, and text) that I want in the email body are getting screwed up. I need a fixed space font to get things lined up. First, when I was just using .body, the text was showing up in the resulting email in a proportional font. So, I figured out that .htmlbody was the way to go, but I'm flailing around - I've managed to specify a fixed space font, but the spaces are getting stripped out of my formatted text strings! *Is there a way to prevent my spaces from getting stripped out? Can someone please help!? Kyle Lehigh Valley, PA Solved my own problem. Used Dick's Clicks RangeToHTML function to put the range I was trying to email into HTML, and sent that in .htmlbody. I don't understand what's happening, at all, but it works, and that's what counts at this point in the evening! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting issues with Excel sheet in email body | Excel Discussion (Misc queries) | |||
How to include Excel charts in Outlook email *body* with VB | Excel Programming | |||
Outlook email url in body | Excel Programming | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming | |||
How to paste cells from Excel into Outlook email body? | Excel Programming |