In excel, how do you make hyperkinks for 200 email addresses without individual entries?
P Peter R Feb 9, 2005 #1 In excel, how do you make hyperkinks for 200 email addresses without individual entries?
D Dave Peterson Feb 10, 2005 #2 You have 200 addresses in A1:A200? If yes, then maybe =hyperlink("mailto:" & a1) in B1 and drag it down.
You have 200 addresses in A1:A200? If yes, then maybe =hyperlink("mailto:" & a1) in B1 and drag it down.