View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SwimOff1 SwimOff1 is offline
external usenet poster
 
Posts: 1
Default Compiling email addresses from individual cells

I'd like to send a single email to a couple hundred associates. Each email
address is listed in a separate cell in a single file column. I've
concatenated the list but can't figure out a way to capture the text (I can
capture the formula but I don't need that) so I can take it and paste it in
the address field. I'm using Excel 2003 SP1.