Export XML and send via email

[nikoko]

I have a database written in 2003 and I am trying to export an XML file so that it attaches to an email automatically when the database opens. I have found a macro to Email a database object ... but not an XML file. I also know that on right clicking a query I can export it as an XML file.

Does anyone know if I can write a module or something that will email an xml file on an event e.g. when the database opens?

Any help would be very much appreciated

 

[ozinm]

the docmd.sendobject allows you to send reports, queties, tables, etc. via email.
It covers a few different formats but not as far as I remember XML.
However, you can programatically export xml to a file using the ExportXML command.

Here's a quick snipet from MSTechNet as an example:

Const acExportTable = 0

Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\Scripts\Test.mdb"
objAccess.ExportXML acExportTable,"Inventory","c:\scripts\test.xml"

I'd suggest looking into using this to output the xml to a temporary file, and then code to either attach it to an email or use it as the body of your message (if that's what you're after).

 

[nikoko]

Thanks Ozinm

I have now managed to output an xml file to a specified folder.

I am now struggling for code to attach this to an email - especially as the users my well have different email programs

Nikki