Copy, Paste Special, Values

SwimOff1 wrote:

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.