Use of a range as an email address in a .SendMail array

S

Simon

Rather then hard wiring the email addresses into the code I wish to
place it in the worksheet then define it as a Range and input the
range in the array as shown below.



How can I get it to work, I think I need something other than .Value



Dim MyPath5 As String, MyRange5 As Range

Set MyRange5 = MyWBConvertor.ActiveSheet.Range("D1")

MyPath5 = MyWBConvertor.Path



''''''''''''''''''''''''''''''''''''''

MyWBLnkZn.SendMail Recipients:=Array("MyRange5")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refer row or column of a range name 6
VLOOKUP Object error 1
Read a range into an array 9
Search an array of sheets for an array of numbers & return count of numbers 11
CSE with function returning an array? 2
Cell values to an array, then array transpose to another workbook 8
Use variable as email reipient names 6
Fill Array from a Range 2

Top