Macro to send email via outlook

[LGMan]

Hi, I've had a simple piece of code running for a while that sends the excel workbook as an attachment to a static email address.
The receipent address is likely to become varaible. I'll be able to pull the mail address from a helper file so that's not a problem.
My problem is when trying to use a variable in the code.

Dim WhoTo As String
WhoTo = Range("F8").Value
ActiveWorkbook.SendMail _
Recipients:= "& WhoTo", _
Subject:="Blah blah "

My problem is the Recipients. I'm struggling with the correct way to use the WhoTo part.
All help or pointers gratefully accepted

 

[PHV]

I'd try this:
Recipients:= WhoTo, _

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Gavona]

If Recipients contains more than a single recipient then you need to make it into an array. Zathras resolved that for me in one of my earliest posts to Tek-Tips thread707-495489

Gavin