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 / November 2007

Tip: Looking for answers? Try searching our database.

Word 2003 MailMerge Question - Fillin Fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JGOV - 06 Nov 2007 02:50 GMT
Hi, I think I am in the right place for this question so here goes.  I am
automating mail merge using word 2003 object model.  My question is, is there
a way to suppress the fillin field prompt?  I do not have access to change
the templates and do not have access to the datasource and this process must
be completely without user input.  Here is my current code.



 //Open Template Document
Dim WordDoc As Word.Document = p_WordApp.Documents.Open(sPath + "\" + sFile)

 //Open DataSource Document
WordDoc.MailMerge.OpenDataSource(Name:=sPath + "\Datasource" + sFile +
".csv", ReadOnly:=False, LinkToSource:=False, Connection:="",
SQLStatement:="", SQLStatement1:="")

 //Verify DataSource has correct fields per its corresponding template
If VerifyMergeFields(WordDoc) Then

With .MailMerge

.Destination = Word.WdMailMergeDestination.wdSendToNewDocument

.SuppressBlankLines = True

With .DataSource

.FirstRecord = Word.WdMailMergeDefaultRecord.wdDefaultFirstRecord

.LastRecord = Word.WdMailMergeDefaultRecord.wdDefaultLastRecord

End With

.Execute(Pause:=False)     <-- Prompts Occur Here

End With

 //Save and Close merged Document

p_WordApp.ActiveDocument.SaveAs(sPath + "\MergedDoc" + sFile)

p_WordApp.ActiveDocument.Close()

 //Close template Document

WordDoc.Close(False, False)

WordDoc = Nothing



 //Check for Error Documents since pause was set to False and save/close
them.

For Each oDocument As Word.Document In p_WordApp.Documents

If Not
Directory.Exists(Path.GetDirectoryName(Reflection.Assembly.GetExecutingAssembly.Location) & "\ErrorLog") Then

Directory.CreateDirectory(Path.GetDirectoryName(Reflection.Assembly.GetExecutingAssembly.Location) & "\ErrorLog")

End If

oDocument.SaveAs(Path.GetDirectoryName(Reflection.Assembly.GetExecutingAssembly.Location) & "\ErrorLog\" & sFile & "_" & oDocument.Name & ".Doc")

oDocument.Close()

Next



           //Remove unneeded datasource and template

File.Delete(sPath + "\Datasource" + sFile + ".csv")

File.Delete(sPath + "\" + sFile)

End If
Doug Robbins - Word MVP - 06 Nov 2007 09:01 GMT
What is the purpose of the Fillin Fields in the mail merge main document?
If they are superfluous, you could insert some code into your routine to
iterate through all of the fields in the document and either link, lock or
delete the Fillin fields.

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

> Hi, I think I am in the right place for this question so here goes.  I am
> automating mail merge using word 2003 object model.  My question is, is
[quoted text clipped - 74 lines]
>
> End If
JGOV - 06 Nov 2007 14:09 GMT
Well i do have code in there to iterate through all the fields and unlock all
the ones that were locked because it was giving errors that it couldn't
update the locked fields.    I did notice that even though the fields were
locked it would still prompt the user for the information.  So I believe that
your suggestion in deleteing the fillin fields would be the best route since
we just press enter and send the fillins blank input anyways.

You did mention linking the fields.   Does this mean that we could fill them
in with data from a preset souce so we don't have to press enter through them
all?

> What is the purpose of the Fillin Fields in the mail merge main document?
> If they are superfluous, you could insert some code into your routine to
[quoted text clipped - 79 lines]
> >
> > End If
 
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.