Mail Range Syntax Query

[bloodmilksky]

Hi Guys,

I am using the below as part of a macro to email some pivot data to a list of customers. but at the moment it only goes to one email address. I tried amending it to look in a specific range for the hyperlink and it errors. can anyone help?

many thanks

Jamie

[U]Receiver = Sheets "Pivot".Select Range"J1".value[/U]            
Topic = "Backorder overview" 
Attachment = strFilename