Depending on what access rights you have to the MySql database you can simply do the following at the DOS Command Prompt:
1. Type Mysql. You should get a prompt back stating "MySql>"
2: Type in SELECT * FROM databasename.tablename INTO OUTFILE 'C:/TEMP/afilename.TXT; In Windows, the Databasename is the directory, and Tablename is the name assigned by your software to the address book table. Hopefully something useful. If you have the right table, you should find the OUTFILE created in C:/TEMP. Otherwise you probably have some access rights issue that your Admin might help with.
3. Type in QUIT
The file created in 2. above can now be opened and edited in Microsoft Excel to get column names matching the names required by Pegasus Mail (see Helpfile) and unwanted columns deleted.
File can then be saved as afilename.CSV All being well you can then import afilename.CSV into Pegasus Mail
HTH
Martin
<p>Depending on what access rights you have to the MySql database you can simply do the following at the DOS Command Prompt:</p><p>1. Type Mysql.&nbsp; You should get a prompt back stating "MySql&gt;" </p><p>2: Type in SELECT * FROM databasename.tablename INTO OUTFILE 'C:/TEMP/afilename.TXT;&nbsp; In Windows, the Databasename is the directory, and Tablename is the name assigned by your software to the address book table. Hopefully something useful.&nbsp; If you have the right table, you should find the OUTFILE created in C:/TEMP. Otherwise you probably have some access rights issue that your Admin might help with.
</p><p>3. Type in QUIT</p><p>The file created in 2. above can now be opened and edited in Microsoft Excel to get column names matching the names required by Pegasus Mail (see Helpfile) and unwanted columns deleted.</p><p>File can then be saved as afilename.CSV&nbsp; All being well you can then import afilename.CSV into Pegasus Mail</p><p>HTH</p><p>Martin
</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p>