var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Mail Merge
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?
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"
set objDb = nothing
Set objAccess = nothing
The path is correct as I have used it elsewhere in the site. But it comes up with an error.