Thread: Can't Contenate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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