Hi All,

I have an access database which takes data from the tables and mail merges it into a word document and saves the resultant doc file.

Can someone tell me how I can run the vba module in access which does this from an ASP page?

Thanks

why don't you write the whole thing dynamically in asp and let user put any text they want to. All you have to do is bring up sending info from access.
It makes it easier IMO.

Its a large 5 page document, which they fill in online and is input into an access database for storage. Then this is merged into a word document and emailed to them for reference.

I think the way around it I have found it to call a macro which calls the script in access, but I'm still having problems. The script is below

<%
Set objAccess = Server.CreateObject("Access.Application")
objAccess.Visible = False
objAccess.OpenCurrentDatabase "F:\websites\ledburyremovalsltd.co.uk\_wibble\Ledb urynet.mdb"
Set objDb = objAccess.CurrentDb()
macroname = "mroMailMerge"
objDb.DoCmd****nMacro macroname
set objDb = nothing
objAccess.Quit acQuitSaveNone
Set objAccess = nothing
%>

The path is correct as I have used it elsewhere in the site. But it comes up with an error.