Export data as text for layout

[Debby]

Hi, all
I need to create a directory using names, addresses, phone numbers that are stored in an Access database. I need to be able to add words to the text, eg. Fax: or Home Phone: before some of the data that will print, as well as layout codes that InDesign uses (that will be invisible in the final project) I also need to be able to put two fields on one line (eg FirstName and LastName) without extra space showing up between them.
I can't see any way to do this, the reports are so heavily formatted. It was a piece of cake to do in PCFile but it is getting embarrassing to go back to a program that doesn't even support a mouse. HELP!!
Debby

[RuralGuy]

Are you simply talking about creating a Report that will print out?

[Debby]

What I need is a very specifically formatted report that can be imported into a layout program (InDesign) without all the extraneous formatting in the standard reports that Access creates, and with the ability to add text to the report. I just need plain text, that I can set up, for example
as below, where the BOLD words are the same for each record, eg:
<HEADLINE>John Smith
<SUBHEAD>Tasty Diner
<TEXT>1000 Maple St.
<TEXT>Our Town, TN 30003
<TEXT>PHONE: 333-333-5555
<TEXT>FAX: 333-444-5555
Some of this would print in the final version, the first words are codes I use for layout. I know a lot about layout but cannot figure how to export records or create reports or queries to do this.
Thanks for any help.

[RuralGuy]

You may want to look at the FileSystemObject Object.