Easiest way to get semicolon-delimited list out of excel

[tina2]

What am I missing here? I need to send out a mass e-mail from a spreadsheet. I do not need to save the list as a distributions list, or even an address list. I was thinking that the quickest way would be to export the list from excel into a semicolon-delimited list (I swear I have done this before!) but I can't figure it out. I even tried to save the sheet as a .csv and doing a find & replace on the commas, but that is not working for me either...

Any suggestions? I don't want to spend a lot of time on this...

Kristine

 

[SkipVought]

Hi,

Do you have stuff like this in a cell

a@b.com; c@d.com; e@f.com

You can use the Data/text to columns wizard.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[tina2]

Actually, I have a column with e-mail addresses that I'd like to get in the format you describe. The purpose is to be able to copy the whole string into the BCC feld in Outlook and send an e-mail to all of them...

 

[chandlm]

Tina,

you could try something like this

Sub output()
Open "C:\test.txt" For Output As #1


Print #1, "Tom@tom.com" & ";" & "Dick@dick.com" & ";" & "Harry@harry.com"

Close #1

End Sub


Matt