View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mailmerge Labels pulling info from Access and putting it intoWord

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?