Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can you remove words from a mergefield using field codes?
We have a wrod document which we merge a field from our database too. The
database outputs "First name Middle name Surname" we would like our letters to say "Dear Paul" rather than "Dear Paul Jon Humphries". I've been looking for a merge field code which could be used to purely pull through the first word, but have been unsucessful. Can anyone help/advise? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can you remove words from a mergefield using field codes?
You will have to separate the data in the data source to achieve what you
are after. -- 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 "ZeonAutonomy" wrote in message ... We have a wrod document which we merge a field from our database too. The database outputs "First name Middle name Surname" we would like our letters to say "Dear Paul" rather than "Dear Paul Jon Humphries". I've been looking for a merge field code which could be used to purely pull through the first word, but have been unsucessful. Can anyone help/advise? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can you remove words from a mergefield using field codes?
Hi ?B?WmVvbkF1dG9ub215?=,
We have a wrod document which we merge a field from our database too. The database outputs "First name Middle name Surname" we would like our letters to say "Dear Paul" rather than "Dear Paul Jon Humphries". I've been looking for a merge field code which could be used to purely pull through the first word, but have been unsucessful. Can anyone help/advise? Word doesn't provide any facility for manipulating text. It's not possible to pull out a single word, or a number of characters, or anything of that nature. The best thing to do would be to redesign the database. The other possibility - if the database supports it (unfortunately you don't mention what kind of database this is) - would be to run a query in the database that pre-processes the information before passing it to Word. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Date property in a form field | Microsoft Word Help | |||
how to suppress a line having a nil or zero value in a merge file | Mailmerge | |||
Hiding Field Codes | Microsoft Word Help | |||
Suppressing Merge Field and text before/after | Microsoft Word Help | |||
Unwanted spaces in address on envelopes | Mailmerge |