Export from Access to Excel

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Can an export from Access (through a macro) be set up to
where you can send it to Excel, but send several exports
to the same workbook on different worksheets? I need to
send several queries to people all the time and want to
automate it so I can click a macro and it will email in
the Excel workbook all in one attachment. However, I'm
not up on programming so I would need to stick with macros.

Thanks for your help!
Martin
 
Martin,

Give Gadami a try (http://www.kripsoft.com/pages/2/index.htm). Insert
your database connection information and queries in an XML file (see
examples shipped with product), and run GadamiConfig.exe to send the
emails out. For an individual email you can provide more than one
Access query by separating them with semi-colons. The output of each
query will then be contained on a separate worksheet of the same
workbook attachment.

You will need to install the .NET Framwork 1.1 if you haven't already.
The product is free to use for sending out up to 100 emails at a
time, and has a nominal cost if you want to send out more.

-Krip
 
Back
Top