Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2006

Tip: Looking for answers? Try searching our database.

Mail Merge Failure

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott - 23 Jan 2006 14:51 GMT
Word 2003 latest updates

I have a Mail merge document that every time the user opens it I want
it to perform a merger.  The document is not complex.  It has something
close to 40 fields on it

What happens is the user selects certain records to merge then I save
those records out to a database with a view attached to the records.

I want the program to shell a Mail Merger template out and have word
perform a mail merge immediately at start up.  I get a number of errors

Opening this document will run the following command

MY SQL Statement into the database

Data from your database will be placed in the document.  Do you want to
continue?

I click 'yes' and then I get
Record 1 contained too few data fields.
Record 2 contained too few data fields.
Record 1 contained too few data fields.

Then I get a box that says invalid merge fields.

I cancel through all the fields and the document comes up with all
sorts of errors.

Fine however if I run this macro specific after the document has opened
it runs fine no changes?

What's happening how come I get errors running the Marco right away
versus waiting until the document is completely loaded?
Doug Robbins - Word MVP - 23 Jan 2006 18:11 GMT
See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Word 2003 latest updates
>
[quoted text clipped - 30 lines]
> What's happening how come I get errors running the Marco right away
> versus waiting until the document is completely loaded?
Scott - 24 Jan 2006 14:11 GMT
The article is what I was looking for thanks.  I think I will level the
security in there and let them open the application for themselves.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.