RE: How do you export contacts AND preserve groups?
Hi all,
We had the same problem (3,000 contacts in groups of several hundreds) and finally found a solution that is very easy.
The adresses are clear and fully written in the Cci field when you send a mail. So The easiest way to export and preserve groups is to :
- Send an email to each group separately to warn them for example, that you have a new email adress / Or open an email you sent to each groupe in the past.
- Then copy the Cci: field with all the adresses of one group.
- Open Notepad or Textedit and paste the adresses of that group. They are all seperated with ";".
Either you can also paste that directly in your new email account, or you need a better file than that. In our case, we needed to paste one adress per line, and with " ; " in a text field. So what we did was :
- Save that text file with all the adresses, naming it for example "group1.csv". You need to change the extension to csv.
- Open that CSV in Excel or its equivalent with Open Office.
- Choose the " ; " as a seperating caracter. Then it will put all the adresses horizontally, one per column.
- Then, Copy that long line.
- Create a new page or file.
- Click 'Edit' / 'Edition', 'special paste' , and click 'transpose'. (sorry, it may not be the right words cause i'm translating directly from french)
Then you have all the adresses from ONE group, listed vertically and without ";". Just copy it and paste wherever you need.
This question dates back to 2006. Five years ago, but I hope it can still help.
Bye
|