I'd like some input regarding these delimited file extensions. I have a list
of email addresses that I'd like to paste quickly into their respective email
messages.
However, I'm not experiencing any luck when using any of the text based file
options. A word from someone who's done this b4?
Cheers!
Assuming your email addies are in a column, just copy/paste into Word, then
(you could record this as a macro):
Edit--gt;Paste special as Unformatted Text.
Ctrl H
Type ^p into the Find what box.
Put a semi-colon in the Replace with box.
Replace all.
Also, my Outlook 2003 does not care if it's commas or semi-colons...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com
quot;e_dog95quot; gt; wrote in message
...
gt; I'd like some input regarding these delimited file extensions. I have a
gt; list
gt; of email addresses that I'd like to paste quickly into their respective
gt; email
gt; messages.
gt;
gt; However, I'm not experiencing any luck when using any of the text based
gt; file
gt; options. A word from someone who's done this b4?
gt;
gt; Cheers!
- Sep 10 Mon 2007 20:39
Saving Excel sheet as a semicolon delimited file (.csv)
close
全站熱搜
留言列表
發表留言