I participated as a vendor in a local bridal show and was provided with access to a list of all the brides who registered with their contact information - including email addresses. I’m sure this is pretty common but I am having major issues pulling the emails out of the file they provided and putting it into the BCC field in my email message.
They provide the list in the following formats:
.csv - quote/comma delimited text file
.tab - tab delimited text file
.xls - an Excel spreadsheet format
.dif - a Data Interchange Format file
I am working on a Mac so I’ve tried both the pdf and Excel spreadsheet but it is in a table format so I can highlight and paste the email addresses but they drop into word still as a list like this
janedoe@aol.com
johndoe@yahoo.com
janedoe@yahoo.com
So the return after each address is causing problems when I try to email it. I need each one to have only a comma after it. Has anyone had to do something like this and solved the problem somehow? Are you familiar with the other formats and how to manipulate them? HELP!
August 5th, 2009 at 12:54 am
Use the find and replace function to change all the returns into commas. Copy and paste them into the e-mail address field. If the .CSV format is set up right the commas will already be there when you open it with a text editor. Or again you can use ‘find and replace’ to place the commas use Word or Notepad to open the .CSV file.