![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
From Access I need to send a multiline email. I have been able to do this
with no problems if the message is short but this is a complicated text body. I have entered "& vbCrlf" after each line return. When I send myself a test message, I see just the last line of the email. How do I "string" the lines of the email togther? (Newbie here.) Thanks in advance for your help. |
Ads |
#2
|
|||
|
|||
![]()
Please show a code snippet.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Danu" wrote in message ... From Access I need to send a multiline email. I have been able to do this with no problems if the message is short but this is a complicated text body. I have entered "& vbCrlf" after each line return. When I send myself a test message, I see just the last line of the email. How do I "string" the lines of the email togther? (Newbie here.) Thanks in advance for your help. |
#3
|
|||
|
|||
![]()
Here are a few lines:
objSafeMsg.Body = "Good Morning," & vbCrLf 'separate lines by adding a vbCrlf at the end of the line. objSafeMsg.Body = "" & vbCrLf objSafeMsg.Body = "This portion of the text is several lines in length but one paragraph." & vbCrLf objSafeMsg.Body = "" & vbCrLf objSafeMsg.Body = "This is a continuation of the email message." & vbCrLf objSafeMsg.Body = "" & vbCrLf objSafeMsg.Body = "Thank you." & vbCrLf When I send a test email, all I see is "Thank you." Thanks for your help. "Sue Mosher [MVP-Outlook]" wrote: Please show a code snippet. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Danu" wrote in message ... From Access I need to send a multiline email. I have been able to do this with no problems if the message is short but this is a complicated text body. I have entered "& vbCrlf" after each line return. When I send myself a test message, I see just the last line of the email. How do I "string" the lines of the email togther? (Newbie here.) Thanks in advance for your help. |
#4
|
|||
|
|||
![]()
In each line you are overwriting the previous Body, not appending to it.
Try something like this: objSafeMsg.Body = objSafeMsg.Body & "" & vbCrLf That appends whatever is new to the existing Body. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Danu" wrote in message ... Here are a few lines: objSafeMsg.Body = "Good Morning," & vbCrLf 'separate lines by adding a vbCrlf at the end of the line. objSafeMsg.Body = "" & vbCrLf objSafeMsg.Body = "This portion of the text is several lines in length but one paragraph." & vbCrLf objSafeMsg.Body = "" & vbCrLf objSafeMsg.Body = "This is a continuation of the email message." & vbCrLf objSafeMsg.Body = "" & vbCrLf objSafeMsg.Body = "Thank you." & vbCrLf When I send a test email, all I see is "Thank you." Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to add scroll barto multiline text box | Long Nguyen | Outlook - Using Forms | 0 | March 30th 06 09:27 AM |
email using redemption | Richard | Outlook and VBA | 10 | March 24th 06 09:16 AM |
Send email using redemption | Richard | Outlook - General Queries | 3 | March 23rd 06 02:44 AM |
Redemption | Christoph | Add-ins for Outlook | 5 | March 6th 06 04:26 PM |
multiline appointments | tinaa | Outlook - General Queries | 0 | February 14th 06 06:07 PM |