On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportFormattedFixed.MDB" which illustrates how print a
header for an exported record. Adding a footer would be similar. I'm not
sure of the specifics of you problem, so I can't tell you how to modify the
code to match. However, if you have any questions, just let me know.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"KP" wrote in message
...
Hi "efandango"

I am doing something very similar - would you be willing to share your
query/export specification and the module you used to generate the KLM
file?
It would save me a lot of time!
Thanks for considering,


"efandango" wrote:

I have an address query which ouputs a single field to text strings for
Google Earth .kml file format parameters.

The problem is that the .kml file requires a header and footer text to be
inserted. Does anyone know how I can pre-insert the Header and Footer
into a
standard text file, and then save it with a '.kml' extension, for example
'Addresses.kml'

This is the Header:

?xml version="1.0" encoding="UTF-8"?
kml xmlns="http://earth.google.com/kml/2.0"
Document
nameAddress List/name
Folder
nameLocations/name
open1/open

Output Field: [kml Address]

This is the Footer:

/Folder
/Document
/kml