I need to be able to create a tab delimted file created
from 3 access tables, but it needs to be almost totally
automated as I have 12 salesmen that are not totally
computer literate.  They will need to be able to do this
and send the tab file via e-mail.  Please advise.

Mike

You'll want to create a stored query that joins the tables appropriately and
includes the fields you want from each query.  You'll then want to go
manually through the export process once, but click the Advanced... button
before the end and save the export specification under a name you can refer
to later.  Now you can build either a true macro that uses the TransferText
action to export that query using the named export specification, or
(better) write a subroutine in a standard module to do it using the
TransferText method of the DoCmd object.  Your subroutine could even use the
SendObject method to send the exported file via e-mail to wherever it's
supposed to go.  You can run the macro or call the subroutine from a button
that you can place on the toolbar or on a form.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(to reply via e-mail, remove NOSPAM from address)