Can't Contenate
 

From Ron de Bruin's site:
http://www.rondebruin.nl/mail/folder2/files.htm

I tried the following piece of code:
With OutMail
.To = cell.Value
.Subject = "Weekly Forecasting"
.Body = "Hi " & cell.Offset(0, -1).Value & "Please view the
_ attachment for this week's forecasting."

The part after .Value gets truncated. Not sure why though. I tried to put
quotes around the whole body, but Excel wouldn't allow that (text turned
red). Any ideas as to what I am doing wrong?

Thanks,
Ryan---

--
RyGuy

Can't Contenate
 

Hard to tell with the wrapping that is going on but probably this...

..Body = "Hi " & cell.Offset(0, -1).Value & "Please view the " & _
"attachment for this week's forecasting."

You have to close off the text string and add the & before adding the line
connector.
--
HTH...

Jim Thomlinson


"ryguy7272" wrote:

From Ron de Bruin's site:
http://www.rondebruin.nl/mail/folder2/files.htm

I tried the following piece of code:
With OutMail
.To = cell.Value
.Subject = "Weekly Forecasting"
.Body = "Hi " & cell.Offset(0, -1).Value & "Please view the
_ attachment for this week's forecasting."

The part after .Value gets truncated. Not sure why though. I tried to put
quotes around the whole body, but Excel wouldn't allow that (text turned
red). Any ideas as to what I am doing wrong?

Thanks,
Ryan---

--
RyGuy

Can't Contenate
 

.Body = "Hi " & cell.Offset(0, -1).Value & "Please view the _
attachment for this week's forecasting."

You cannot use a space and underscore to break a line of code in the middle
of text enclosed in double quotes. If you want to use a line break, insert it
in a section of the line that is not enclosed in double quotes.

..Body = "Hi " & cell.Offset(0, -1).Value & _
"Please view the attachment for this week's forecasting."

--
Regards,

OssieMac


"ryguy7272" wrote:

From Ron de Bruin's site:
http://www.rondebruin.nl/mail/folder2/files.htm

I tried the following piece of code:
With OutMail
.To = cell.Value
.Subject = "Weekly Forecasting"
.Body = "Hi " & cell.Offset(0, -1).Value & "Please view the
_ attachment for this week's forecasting."

The part after .Value gets truncated. Not sure why though. I tried to put
quotes around the whole body, but Excel wouldn't allow that (text turned
red). Any ideas as to what I am doing wrong?

Thanks,
Ryan---

--
RyGuy

Can't Contenate
 

Damn space!! Both worked!!
Thanks guys,
Ryan--
--
RyGuy


"OssieMac" wrote:


.Body = "Hi " & cell.Offset(0, -1).Value & "Please view the _
attachment for this week's forecasting."

You cannot use a space and underscore to break a line of code in the middle
of text enclosed in double quotes. If you want to use a line break, insert it
in a section of the line that is not enclosed in double quotes.

.Body = "Hi " & cell.Offset(0, -1).Value & _
"Please view the attachment for this week's forecasting."

--
Regards,

OssieMac


"ryguy7272" wrote:

From Ron de Bruin's site:
http://www.rondebruin.nl/mail/folder2/files.htm

I tried the following piece of code:
With OutMail
.To = cell.Value
.Subject = "Weekly Forecasting"
.Body = "Hi " & cell.Offset(0, -1).Value & "Please view the
_ attachment for this week's forecasting."

The part after .Value gets truncated. Not sure why though. I tried to put
quotes around the whole body, but Excel wouldn't allow that (text turned
red). Any ideas as to what I am doing wrong?

Thanks,
Ryan---

--
RyGuy