Here is what I have.
A ".txt" file that contains valid e-mail addresses seperated by commas.
This was created by copying a collection of 200+ e-mail addresses that were seperated by commas. Then I pasted them into a blank Notepad document. Then saved the file with the default ".txt" extension.
Here is what I wish to accomplish:
Take the text file containing the data and produce a file that could be used to import the e-mail addresses into Outlook,
Outlook Express, Eudora or any other e-mail program the client is using.
Here is what I have tried:
Opened a blank worksheet in Excel. Created a header in cell A1 named "email address". Pasted the list of e-mail addresses from the Text file into cell A2. Save as a csv file. This Excel CSV file when imported produces a single contact with all addresses that were pasted into cell A2.........
Here is what I believe needs to occur:
Importing/Inserting/Copying the list of e-mail addresses into individual cells in Column A(with cell A2 reserved for the Field Name "email address")
Can this be automated via a Script, Macro etc? I am a novitiate with these techniques, but will pursue those paths if necessary.
Thanks for the help,
I have enjoyed your site's support and knowledge base.