Hi iambalrog

This is not possible when you use SendMail
If you use Outlook you can use the Outlook object model

See my mail site
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"iambalrog" wrote in message
...

Apologies, didnt mean to be to vague.

Emailing the sheet

The macro formats and selects relevant data, saves a seperate file, and
ends in the syntax:
ActiveWorkbook.SendMail Recipients:="Tim McHugh", Subject:="Your
Reports"

This emails succesfully emails a copy of the workbook which is what i
want - i just want to also put some automatic message text in there
along the lines of:
"Dear Tim, Please find attached your monthly reports,Kind Regards, Me"

The heading rows (and finding the next one)
I tell it in an input box where the first cell i want to format is. It
then selects the rest of that row that contains values and proceeds to
format that row (see syntax below-ive cut off the extensive formatting
for ease).
The problem i have is making it search for the next heading row (all it
needs to do is find the next event where a cell = the same value as the
start cell)
Once its completed all header formatting on that sheet i want it to
automatically go to the next sheet and ask me to tell it the startcell
again.

Dim StartFormat As String
Dim Format As String
StartFormat = InputBox("Enter a start cell reference (e.g. A1)",
"Start Cell")
Range(StartFormat).Select
Format = ActiveCell.Value
Range(ActiveCell, ActiveCell.End(xlToRight)).Select

Thanks!


--
iambalrog
------------------------------------------------------------------------
iambalrog's Profile: http://www.excelforum.com/member.php...o&userid=26977
View this thread: http://www.excelforum.com/showthread...hreadid=494080