Importing Recipiants
Posted: Tue May 20, 2008 3:43 pm
Hi,
I have an .xls file with a long list of emails that I would like to import into OpenEMM. When I convert the file to .csv it comes up in the following format:
then when I create an access table and export it as csv I get the following format:
Each time I try to import only one email address appears in the preview page and I get the following error on the result page. "Errors in gender values: 11"
When I click on the disk symbol beside the above error I get the following:
Should I be using a different program to create the .csv files? If so how do I go about converting the old ones, as all my email addresses are saved into .xls.
I am pretty sure that I am doing something simple wrong here. If anyone would be able to help it would be greatly appreciated.
I have an .xls file with a long list of emails that I would like to import into OpenEMM. When I convert the file to .csv it comes up in the following format:
Code: Select all
gender,email,mailtype
Unknown,a@b.c,html
Unknown,a@b.c,html
Unknown,a@b.c,htmlCode: Select all
1;"Unknown";"a@b.c";"HTML"
2;"Unknown";"a@b.c";"HTML"
3;"Unknown";"a@b.c";"HTML"When I click on the disk symbol beside the above error I get the following:
Code: Select all
1;"Unknown";"a@b.c";"HTML"
2;"Unknown";"a@b.c";"HTML";Error, Text missing!gender
3;"Unknown";"a@b.c";"HTML";Error, Text missing!genderI am pretty sure that I am doing something simple wrong here. If anyone would be able to help it would be greatly appreciated.