Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Reasons why you might get this include:
a. you are merging from a query and the query is not actually retrieving the data you expect b. you are merging from an Access query (or possibly table) that uses a lookup field to store your person type. Sometimes you get a numeric value (that corresponds to the lookup index) rather than the text you want - that can happen even though the query behaves correctly in Access c. in some versions of Word, when you merge from some data sources (e.g. Excel) and there is a blank field in the data source, sometimes Word fills in the value from the previous record None of those sounds particularly convincing in this case, but if that doesn't help, it would be helpful to have more information, e.g. a. which version of Word b. what is the data source? If it is a query such as an Access query, can you provide the Query SQL? c. what type of merge are you performing d. what actually appears in the "type" field in the merge - is it the type (speaker, vendor etc.), but the wrong type, or is it something else altogether? Peter Jamieson http://tips.pjmsn.me.uk On 11/11/2009 03:20, Dee wrote: I have set up a merge to create name badges. It pulls the first and last name of a person and pulls from a field that states the type of person. (speaker, vendor, staff, etc...) The merger works except for one problem. When the merge fills in the type of person, it does not match up to what is in the database. I'm not quite sure if it scrambles it or what it does but they don't match up. What could cause the one field not to match up? |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merging info from Access into Word document | Microsoft Word Help | |||
Using a database to access info in Word | Microsoft Word Help | |||
How do I create a Word template pulling information from Access? | Microsoft Word Help | |||
Failure to save info entered in User Info, envelopes & Labels | Microsoft Word Help | |||
Putting lines in a word document & being able to key info on that | Microsoft Word Help |