Re: Avery Labels with MySQL

["Gary Huntress" <ghuntress@xxxxxxxxxxxx>]

Far less complicated than that.   I will assume that MyODBC is installed and
a data source has been created that points to the mysql data of interest.

Load MS Access.   On the table tab, select "new/link table"  (or import if
you prefer).  In the "files of type" selection, choose ODBC, then pick your
source, and table.

Then go to "reports" and select "label wizard"

Pick the avery label #  that you want to use, then let the wizard help you
select fields/layout, etc.

Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org


----- Original Message -----
From: "Todd Williamsen" <todd@xxxxxxxxxxxxxx>
To: <kurt@xxxxxxxxxxxxxxxx>; <mysql@xxxxxxxxxxxxxxx>
Sent: Sunday, December 02, 2001 9:50 PM
Subject: RE: Avery Labels with MySQL


> I guess I would run a query to pull the data out into a CSV file, then
> import it into Excel, then convert it to a Word document.  Or run a
> query where MS Access pulls the data and syncs it with a database in
> Access, then export the table into Excel or Word or Outlook PST file
>
> Thank you,
>
> Todd Williamsen, MCSE
> home: 847.265.4692
> Cell: 847.867.9427
>
>
> -----Original Message-----
> From: kurt@xxxxxxxxxxxxxxxx [mailto:kurt@xxxxxxxxxxxxxxxx]
> Sent: Sunday, December 02, 2001 7:32 PM
> To: mysql@xxxxxxxxxxxxxxx
> Subject: Avery Labels with MySQL
>
>
> Hi,
>
> I am creating a PHP/MySQL web based app that takes contact information
> in.  I would like to be able to make Avery Address Labels with the data
> that I get.
>
> Any ideas on how to do this?  I'm guessing MS Access might be able to
> help with this (if it handles MySQL) cause I know the Office products
> have Avery Wizards.
>
> Thanks in advance for any help.
>
> Kurt Giessler
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread92873@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
> <mysql-unsubscribe-todd=williamsen.net@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread92874@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-ghuntress=mediaone.net@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92876@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php