Online Manual Welcome Setup Overview Composing Details Managing Data Text Datasources   Excel Datasources   Access Datasources   ODBC Datasources   Field Type Control   ODBC Drivers   List Management Scripting Scheduling More Help Mailer Home Download Mailer . Version History What's new in the latest version Contact Support We are here to help you via email. We will do our best to get back to you right away. Explore M5 Mailer Take the bulk out of email! TM Use your own data Personal email merge Send individual email HTML and/or text Handy email templates Explore M5 Subscriber Web-based list management made simple! Simple subscribe tool Opt-in confirmed Track reads and clicks Custom matching look Free for up to         5000 contacts

Connecting to an Excel Spreadsheet

Using Microsoft Access or Excel as a tool to help you manage your data, rather than relying on a simple text-based database, may save you a great deal of time in the long run.

You can very easily connect Mach5 Mailer to an already existing Excel database. Below are some details which may help you with that process

Using Microsoft Excel

Excel is really a spreadsheet program, but a spreadsheet can be an excellent data management tool. We recommend always using the direct excel connection because it is simpler.

After you decide to use a Direct Excel connection and choose your Excel spreadsheet file, you need to tell Mailer what information inside the Excel spreadsheet will be used in your mailing. There are some choices here.

Mailer can figure out what range of data is in your Excel spreadsheet for you, and can even recalculate that range if you add or delete rows from your spreadsheet later. Just choose the "Select range of cells as table" option, and then click on the "Verify range" checkbox.

Other more advanced ways to use Excel

The other choice, "Select a table from table list," is useful if you want to define a portion of your Excel spreadsheet or set of worksheets to use as a data source. To use this feature you need to create a "Named Table" in Excel. In Excel, first select a range of cells. You can also select entire columns if you wish. Then, under the "Insert" menu, choose the "Name" menu item and the "Define…" submenu. When the dialog box appears, just type a name for your selection, such as "Email Merge," and press the Add button, and close. Consult the Excel documentation for more information.

Named tables appear in the list for the spreadsheet you have chosen. If there are no named tables defined, the list will be empty.

If you are familiar with SQL, or have a table defined in your Excel spreadsheet that you want to use, you can use an Excel connection through ODBC. Just check off the "use direct connection" checkbox, and you'll be prompted to choose your database and define the way you want to connect to it.

Home   |   Site map   |   Analyzer   |   Mailer   |   PopMonger   |   Resources   |   Customers and Partners  |   Contact
Mach5 and M5 are registered trademarks of Mach5 Development, LLC.