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 / March 2008

Tip: Looking for answers? Try searching our database.

Fillin once fields sometimes filled in twice

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Walter Briscoe - 06 Mar 2008 12:13 GMT
I am using Word 2003 (11.6359.6360) SP1.

I am having trouble with a merge.

My main document has two { FILLIN "q" \d "d" \o } fields.

Fillin data is acquired in a successful ActiveDocument.Fields.Update.

ActiveDocument.MailMerge.DataSource.Name is unset until I use
ActiveDocument.MailMerge.OpenDataSource to link to a data source.

Dialogs(wdDialogMailMergeRecipients).Show selects the records to merge.

I would like to put a debug probe here but have yet to figure how. I
guess that .Show unintentionally alters ActiveDocument.MailMerge.Fields.

Moving ActiveDocument.Fields.Update to here results in some data being
filled in twice and some being unfilled.

If the number of merged records is more than 7, fillin data for both
fields is again requested during ActiveDocument.MailMerge.Execute.

When debugging, I do not find a Globals window analogous to the Locals
window. The Object Browser seems to deal with the structure of objects
but not object values. It is painful to construct a MsgBox call to show
the members of an object.
Signature

Walter Briscoe

Walter Briscoe - 06 Mar 2008 13:24 GMT
In message <jrURdFWDA+zHFwYK@freenetname.co.uk> of Thu, 6 Mar 2008
12:13:55 in microsoft.public.word.mailmerge.fields, Walter Briscoe
<wbriscoe@nospam.demon.co.uk> writes
>I am using Word 2003 (11.6359.6360) SP1.
>
[quoted text clipped - 22 lines]
>but not object values. It is painful to construct a MsgBox call to show
>the members of an object.

I found the following before the .execute call gave me a "fix".
It leaves me wanting an explanation. ;(
        ActiveDocument.Fields(1).Unlink ' Stop Fillin going again
        ActiveDocument.Fields(2).Unlink ' Stop Fillin going again
        ActiveDocument.Fields(3).Unlink ' Stop Fillin going again

Signature

Walter Briscoe


Rate this thread:






 
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.