Results 1 to 3 of 3

Thread: Mail Merge

  1. #1
    Join Date
    Dec 2003
    Sheffield, UK

    Unhappy Unanswered: Mail Merge

    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?


  2. #2
    Join Date
    Nov 2003
    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.

  3. #3
    Join Date
    Dec 2003
    Sheffield, UK
    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\\_wibble\Ledb urynet.mdb"
    Set objDb = objAccess.CurrentDb()
    macroname = "mroMailMerge"
    objDb.DoCmd.RunMacro 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts