A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Multiline Email using VBA and Redemption



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old April 4th 08, 07:04 PM posted to microsoft.public.outlook.program_vba
Danu
external usenet poster
 
Posts: 2
Default Multiline Email using VBA and Redemption

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  
Old April 4th 08, 07:12 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Multiline Email using VBA and Redemption

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  
Old April 7th 08, 02:32 PM posted to microsoft.public.outlook.program_vba
Danu
external usenet poster
 
Posts: 2
Default Multiline Email using VBA and Redemption

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  
Old April 7th 08, 02:55 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Multiline Email using VBA and Redemption

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 02:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.