0

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 and wont send the email. In the range J1 I also have a Vlookup formula running to match the ac and email address. Any help would be great. 

Receiver = Sheets ("Pivot").Select Range("J1").value 'it errors on this line           
Topic = "Backorder overview" 
Attachment = strFilename
Community
  • 1
  • 1
bloodmilksky
  • 13
  • 1
  • 5

1 Answers1

0

Avoid the use of .Select. See this

How to avoid using Select in Excel VBA macros

Change the line 

Receiver = Sheets ("Pivot").Select Range("J1").value

to

Receiver = Sheets("Pivot").Range("J1").value
Siddharth Rout
  • 147,039
  • 17
  • 206
  • 250