R
ryguy7272
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---
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---