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.

can you display merge fields as a single character?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Katherine S. - 23 Jan 2004 18:01 GMT
A coworker of mine is personalizing a survey questionnaire in Word using data from Access. The merge data is mostly one- and two-digit numbers, and the field names are several characters long. The problem is that the data is being put into tiny little table cells that are too small for the long field names, which makes formatting pretty difficult. Is there a way to display the fields as something shorter than the whole field name? I vaguely remember that in WordPerfect you could display a merge field as a red diamond character, or something

I did suggest he change the Access field names to two-character combinations, but he didn't like the idea. He's got more than 100 fields to keep track of, so I don't really blame him. Any better ideas

Thanks for any help
Katherin

Please remove swearing to reply directly via e-mail
Peter Jamieson - 23 Jan 2004 18:51 GMT
The only things I can suggest are
a. consider using paragraph or character styles so that you
- massively reduce the size of the font used (by changing the font size of
the style) when you are editing, and set the font size of the style back to
the value you want prior to merging
- then use use view|zoom to make everything larger when editing
- use view|normal to view tables
b. create a record in the data source where each field has one letter or
digit and use the preview mode to view the /data/ in that record rather than
the view where you see <<fieldname>> or { MERGEFIELD fieldname }
c. rather than change the Access table field names, use an Access Query to
assign a short name to each field. (the SQL is SELECT longname1 AS `sn1`,
longname2 AS `sn2` etc.). That way, you keep the names you want in the main
tables in the database and compromise solely to solve this problem, plus the
shortname-to-longname mapping is documente din the Query definition so you
can easily rediscover it when you need to do any maintenance.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> A coworker of mine is personalizing a survey questionnaire in Word using data from Access. The merge data is mostly one- and two-digit numbers, and
the field names are several characters long. The problem is that the data is
being put into tiny little table cells that are too small for the long field
names, which makes formatting pretty difficult. Is there a way to display
the fields as something shorter than the whole field name? I vaguely
remember that in WordPerfect you could display a merge field as a red
diamond character, or something.

> I did suggest he change the Access field names to two-character combinations, but he didn't like the idea. He's got more than 100 fields to
keep track of, so I don't really blame him. Any better ideas?

> Thanks for any help,
> Katherine
>
> Please remove swearing to reply directly via e-mail.
Katherine S. - 23 Jan 2004 20:26 GMT
Hi Peter,

Those are great ideas! I'll pass them along. Thanks a lot.

> c. rather than change the Access table field names, use an Access Query to
> assign a short name to each field.

Oops... sorry I oversimplified. That is what I suggested, and I thought it was a good idea too. Now that I have a second opinion I'll suggest it again. :)

Thanks,
Katherine

Please remove swearing to reply directly via 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.