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 2003

Tip: Looking for answers? Try searching our database.

Data Source (File) Creation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EGS3 - 25 Nov 2003 15:28 GMT
I'd like to create a data source with 1,000+ fields.

I'd like the format to be:

Field0001
Field0002
Field0003
.
.
.
Field1000
John
Q
Public
.
.
.
Red
Jane
A
Public
.
.
.
Red

Anyone have a link to instructions on how to create a data
file using this format?

TIA

Ed
Peter Jamieson - 25 Nov 2003 19:41 GMT
I think you can get close to this, but Word needs to have a record delimiter
that is different from its field delimiter. So you could use

Field0001
Field0002
Field0003
.
.
.
Field1000
<tab>John
Q
Public
.
.
.
Red
<tab>Jane
A
Public
.
.
.
Red
<tab>

where <tab> is just a tab character, and each line is ended with a paragraph
mark (if it is a Word document) or a carriage return/line fedd (i.e. a
normal line end in Notepad) if it is a .txt file. You will probably see an
additional field name called AutoMergeField when you list the fields in
Word.

Word will ask what the delimiter characters are when you attach the data
source but you should not see any further dialog boxes.

I've seen some reports that Word XP .txt data files with lots of fields do
not work properly as merge data sources, in which case you will probably get
better results by putting the data, using the same layout, in a Word .doc.
With Word 2003 here this seems to work with 1000 fields.

--
Peter Jamieson - Word MVP

> I'd like to create a data source with 1,000+ fields.
>
[quoted text clipped - 28 lines]
>
> Ed
 
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.