Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
So my current problem is that I can get the text from my sheet into
the email, but I cant get it to bring the formatting too. Here is a portion of my current VBA code: Sub BodyMacro(strbody, email) Sheets("Body").Select Range("B1") = email Calculate For Each cell In Sheets("Body").Range("A4:A33") strbody = strbody & cell.Value & vbNewLine Next End Sub This works exactly how I want it to other than I would like the bold, underline, and italic text in there too. To add to the difficulty, some of the lines of text bounce between all three. Meaning in cell A1 its just not all bold text, it will start off bold, then go to underline, then to regular. I have also done the "Send to Mail Recipient" and I do not like how the text doesn't wrap. If this can be down with it wrapping, I would be open to that suggesting too. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Email from excel: Format dollar amount in outlook body | Excel Programming | |||
TextBox value on an email body with same format | Excel Programming | |||
Macro to Paste Picture in email body from Clipboard | Excel Programming | |||
COPY/PASTE to body of email the format of Excell cell | Excel Programming | |||
Excel Email: Address and portion of body in cell | Excel Programming |