Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |