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 2004

Tip: Looking for answers? Try searching our database.

Record Header Delimiter Box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark Young - 17 Jan 2004 11:45 GMT
I have created a mail merge with the data coming from a
RTF.  I have created a header field and all the necessary
data in the document.  The Field Delimiters are seperated
by a '~' symbol, and the Record Delimiters are seperated
with a '|'.  When I merge I always have to select the
Field and Record delimiters using the above symbols.  Is
there any way of automating this, as I've tried recording
a macro.  This does everything but then brings up the
Record Header Delimiter box so I have to select them.  I'm
presuming it could be a bit of VBA code that is needed,
but I am unsure.  Any help would be appreciated.  Checking
on MS support they say to duplicate the header data, I
have tried this but no luck.
Cindy M  -WordMVP- - 18 Jan 2004 20:36 GMT
Hi Mark,

> I have created a header field and all the necessary
> data in the document.  The Field Delimiters are seperated
[quoted text clipped - 4 lines]
> a macro.  This does everything but then brings up the
> Record Header Delimiter box so I have to select them.

As long as you're not using a paragraph mark (Chr(13) as the
record delimiter you have no chance of suppressing this
dialog box.

If the problem is that your data contains paragraph marks in
the fields, then place each field's contents in "quotes" so
that Word knows when the paragraph marks belong to a field
and when they're record delimiters.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
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.