Visitor Leads can be easily imported to Microsoft Access or Microsoft Excel

The Cape Cod Chamber issues tourism leads bulletins exclusively by e-mail or by fax. These bulletins are a record of who has called, emailed or written to have information on Cape Cod sent to them. We provide these leads as a service to our members.

Visitor Leads can be easily imported to Microsoft Access or Microsoft Excel.

Microsoft Access
1. Save the leads to your computer. Remember where you saved them to.
2. Start microsoft access
3. Open a database
4. Go to the "table" tab
5. Under the "file" menu choose "get external data" and "import"
6. Navigate to where you saved the leads
7. Choose import
8. Follow the steps in the wizard -- the field names are on the first row.
9. You can then use the report wizard to make labels, etc.

Microsoft Excel
1. Save the leads to your computer. Remember where you saved them to.
2. Start Microsoft Excel
3. Under 'data' choose 'get external data' then 'import text file'
4. Follow the steps in the wizard -- the field names are on the first row.

If you import the leads to Excel you can then use the excel file as a data source for a mail merge using Microsoft Word. In Word 2002 (xp) you can mail merge directly from the text file.