Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Me again. I am aware of how to do a mail merge, and more importantly a merge to word from access (I am using Access 2007) but the concept is still the same.

    I right-click the query
    I choose Export...
    I choose Merge it with MS Word
    and than
    I choose Create a new document and link to it...


    that's when it happens...

    I get a dialog box that comes up that says the DB is locked for editing (and none of the choices are workable...enclosing a pic). The DB query is not open, no tables are open, nothing is open in the DB for it to be giving me this dialog. First it said that it was having exclusive issues (so I closed the db and opened it "not in exclusive mode", and that's why I now get this dialog that appears and the query won't merge to word.

    If I try to start from Word...Tables is all that appears when I try to connect to the DB and I need the "query" which doesn't show as an option.

    HELP AGAIN
    Nannette
    Attached Images Attached Images
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='teachesms' post='769763' date='08-Apr-2009 19:36'][/quote]
    I suppose the merge with the query is not possible because you have to input parameters. (I suppose also it is the same query as in the previous post)
    What you can do is create a new table with a maketable query based on qryCustomersByTotalSales and use this new table for your merge from Access or from Word.
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I just went ahead and did it in an Access Report. Just thought not being able to send it to Word was very odd. However, I do expect your absolutely right about the Parameters stopping the process...although I don't recall it ever doing so before.
    Thank you.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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