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!