Reply
 
Thread Tools Display Modes
  #1   Report Post  
Linda
 
Posts: n/a
Default Word mail merge with Access

Why does Word sometimes open another instance of Access when doing a mail
merge? I have forms in Access with hyperlinks to Word merge documents which
are based on queries from the form info. They were working flawlessly. Now,
Word is opening another instance of access and the queries are not returning
any data because the form info is not available in the new instance of
Access. The only thing I have done different is set up Access to open the
switchboard when opened and I set warnings to off in several of the macros
that I run. What would cause Word to start opening another instance of Access?
  #2   Report Post  
Albert D. Kallal
 
Posts: n/a
Default

This is known problem

(it happens when you change the name of your database). A description and
fix is mentioned he

http://www.mvps.org/access/bugs/bugs0011.htm

On the other hand, you might try my sample "super easy word" merge. Not only
does my example avoid your
problem, but also allows you to easily merge just ONE record.

You can give the sample a download he
http://www.attcanada.net/~kallal.msn.../msaccess.html

If it does what you want..then you can read the instructions on how to use
the neat code in your application.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
Mail merge - Word 2003/Access 2000 Russell Farr Mailmerge 7 March 24th 06 01:03 AM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 03:29 PM
Mail merge toolbar unavailable after SP3 R Scott Lowden Mailmerge 1 December 1st 04 07:24 PM
Word mail merge doesn't pick up the addresses in Access database. Julie Tables 1 November 24th 04 02:26 AM


All times are GMT +1. The time now is 02:20 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"