I want to do an e-mail marketing blast through Constant Contact or other e-mailing system and I need to export all my e-mails from FastManager.  I would also like to export the contact name as well.

Note: these instructions will also work for creating mailing lists.  You'll just need to copy and paste the "BAddress" (billing address) or "SAddress" (shipping address) column depending on which one is applicable for your mailing. 

To do this you will need Microsoft Access (or similar database program) and Microsoft Excel (or similar spreadsheet program).

1.) make a copy of your DB.qdb file and paste it to your desktop
2.) rename this file to db.mdb
3.) open it by double clicking on it
4.) on the left you will have a list of tables. You want the CUSTOMERS table. Double click it.
5.) You now need to sort this list so that all the empty e-mail fields are placed up top. This helps with a cleaner "copy and paste" into Excel. To do this click on the E-Mail colum which will highlite this column.
6.) now right click and select sort from A-Z
7.) now right click again and select COPY
8.) Open Microsoft Excel
9.) right click on the first open cell in the upper left hand corner and click PASTE. You now have an excel spreadsheet with all your e-mails in it. This can be exported into Constant Contact or other e-mail program.
10.) To get the names as well.... go right click on the CONTACTS column and select COPY....do NOT sort again
11.) go back into Excel and right click on the 2nd open cell in the top left hand corner which will paste the names in the column directly to the right of the e-mail column.  You now have the contact name that is perfectly aligned to it's appropriate e-mail.

12.)  To get the addresses do the same steps in #10 and #11 above but click on the BADDRESS or SADDRESS column depending on what type of address suits your needs best....and PASTE this into the 3rd column in Excel.