Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports or mail merge? (A2k)

    Looking for opinions. I need to create letters from info stored in my access database. I don't want users to have to open the word documents and then go to the access database and input query parameters. I have a form from which a user will select a class number. Then they will click a button to create the letters for the entire class. I need to loop through the records, since different types of students require different letters. I'm just looking for general opinions, specifics will come later.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reports or mail merge? (A2k)

    Both mail merge in Word and reports in Access should work. I don't know how different the letters will be - if they share a common basis, you might be able to use one mail merge document / report, with conditional parts. If they are fundamentally different, you'll need to use code to select the appropriate document or report for each student. Both options can be fully automated. You should choose mail merge if the letters may need to be edited manually, or need to be stored as documents.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports or mail merge? (A2k)

    Hans,
    Thanks for the additional considerations. How can I avoid getting the query prompt when calling the word document from access? <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> And how do I call the word doc from access? What additional considerations should I have since it's a mail merge document?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reports or mail merge? (A2k)

    You can use DDE to connect to the database; this will recognize form parameters in a query.

    I usually store the Word document without data source (ActiveDocument.MailMerge.MainDocumentType = wdNotAMergeDocument), and create it on the fly using Automation. See <post#=263,603>post 263,603</post#> and <post#=375,939>post 375,939</post#> for examples. This approach is very flexible, and has been working well in many databases for over 6 years now.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports or mail merge? (A2k)

    Ok, last question: would it be possible to embed the word documents in the database and call them from there?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reports or mail merge? (A2k)

    No, that's not a good idea. I'd store them separately; if you put them in the same folder as the database (or a subfolder of that folder, if you prefer), the database can always find them.

  7. #7
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports or mail merge? (A2k)

    What's the code to look in the folder the database is in?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reports or mail merge? (A2k)

    You can use CurrentProject.Path to retrieve the path to the current database.

Posting Permissions

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