Right now I have a Hyperlink with multiple CC's that I would like to put in a list on the worksheet for ease of changing addresses. At the moment I have a link and the addresses are Separated in the Subject Field of the Edit Hyperlink dialog window as so; For%20Blank%20Tomorrow&cc=matt @Blank.com;Elisa @Blank.com
I would like to change this to something like; For%20Blank%20Tomorrow&cc= Cell Z1; Cell Z2
The other solution I have is to add a Hyperlink formula as so;
=HYPERLINK("mailto:" & Q4 & "?cc="& AH3& ";"& AH4& ";"& AH5& ";"& AH6& ";"& AH7&"&subject="& AH1 & "&body=" & AH2, "Order")
Here is where it gets tricky I also have a VBA script that works with the first scenario like this;
Sub SM_sort()
'
' SM_sort Macro
'
Range("Q5").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
ActiveSheet.Range("L4:O42").AutoFilter Field:=4, Criteria1:="SM"
ActiveSheet.Range("L4:O42").AutoFilter Field:=2, Criteria1:="<>"
Range("L4:M43").Select
Selection.Copy
End Sub
But I am having trouble getting it to activate the Hyperlink in the Formula set up. can someone please help with this challenge?
I would like to change this to something like; For%20Blank%20Tomorrow&cc= Cell Z1; Cell Z2
The other solution I have is to add a Hyperlink formula as so;
=HYPERLINK("mailto:" & Q4 & "?cc="& AH3& ";"& AH4& ";"& AH5& ";"& AH6& ";"& AH7&"&subject="& AH1 & "&body=" & AH2, "Order")
Here is where it gets tricky I also have a VBA script that works with the first scenario like this;
Sub SM_sort()
'
' SM_sort Macro
'
Range("Q5").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
ActiveSheet.Range("L4:O42").AutoFilter Field:=4, Criteria1:="SM"
ActiveSheet.Range("L4:O42").AutoFilter Field:=2, Criteria1:="<>"
Range("L4:M43").Select
Selection.Copy
End Sub
But I am having trouble getting it to activate the Hyperlink in the Formula set up. can someone please help with this challenge?