Hi,

I am trying to send an email from within vb (which is no problem) but I want
to be able to insert multiple rows within the message body of the email.
Here is my code but it is only putting in one line.

With cmd
Set .ActiveConnection = cn
.CommandType = adCmdStoredProc
.CommandText = "proc_email_admin"
.Parameters("@sbj").Value = "Tenants"
For i = LBound(name) To UBound(name)
If name(i) <> "" Then
.Parameters("@msg").Value = name(i) & " - " & address(i) & " - "
& contract_date(i) & Chr(13)
End If
Next i
.Parameters("@recipient").Value = email_address
.Execute
End With

Any help on this would be appreciated.

Thanks

Damon

"Damon" <nonsense@nononsense.com> wrote in message
news:b8bbd.87$Lr6.78@newsfe2-gui.ntli.net

Chr(13) is a carriage return but you need both that and Line Feed to
indicate end-of line
Try using Chr$(13) & Chr$(10) or vbCRLF or vbNewLine


--
Reply to the group so all can participate
VB.Net... just say "No"

"Damon" <nonsense@nononsense.com> wrote in message
news:b8bbd.87$Lr6.78@newsfe2-gui.ntli.net...

& contract_date(i) & Chr(13)

Try using vbCrLf instead of Chr$(13). A bare carriage return is not a line
terminator in any system but the Mac.

"Bob Butler" <tiredofit@nospam.com> wrote in message
news:ug4wWRTsEHA.3320@TK2MSFTNGP15.phx.gbl...


What's the difference between vbNewLine and vbCrLf ?

Mike

Mike wrote:


None.
But there might have been in the future, had VB continued to evolve.



Bob

"Bob O`Bob" <filterbob@yahoogroups.com> wrote in message
news:416D4D09.594F@yahoogroups.com...

Everywhere I have been has used vbCrLf. Although having seen vbNewLine, I
think I'll start using this for readability.

Mike

I thought vbCrLf forces a Carriage Return / Line Feed but vbNewLine uses
what ever the system requires for a new line (determines it at runtime)...

--
Chris Hanscom - Microsoft MVP (VB)
http://www.veign.com
--

"Bob O`Bob" <filterbob@yahoogroups.com> wrote in message
news:416D4D09.594F@yahoogroups.com...

"Mike" <www.evolvedsoftwarestudios.com> wrote in message
news:eK2PipTsEHA.2144@TK2MSFTNGP10.phx.gbl

vbCRLF is *always& carriage-return & linefeed

vbNewLine is defined as a platform-dependent line terminator

AFAIK the only difference is in a VBA macro on a MAC
--
Reply to the group so all can participate
VB.Net... just say "No"

"Mike [MCP VB]" <www.evolvedsoftwarestudios.com> wrote in message
news:%23CNSgyTsEHA.3556@TK2MSFTNGP10.phx.gbl
<cut>

IMO vbCrLf is a better choice for readability since it specifies exactly
what it contains; also, after working for years on a proprietary system
where "New Line" was a synonym for "Line Feed" I automatically read it as
not including the CR character and it still jars every time.

--
Reply to the group so all can participate
VB.Net... just say "No"

Bryan Dickerson wrote:


funniest thing I've read all day.



Bob
'course, it's only 9:30 and I've been awake barely an hour
--