Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dee Dee is offline
external usenet poster
 
Posts: 98
Default Mailmerge Labels pulling info from Access and putting it into Word

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?
  #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?

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging info from Access into Word document microsoft office novice Microsoft Word Help 2 December 9th 08 02:52 PM
Using a database to access info in Word James Microsoft Word Help 0 January 23rd 08 02:12 AM
How do I create a Word template pulling information from Access? SV[_2_] Microsoft Word Help 1 August 17th 07 10:37 PM
Failure to save info entered in User Info, envelopes & Labels jim longley Microsoft Word Help 1 May 30th 07 08:15 PM
Putting lines in a word document & being able to key info on that Classic Microsoft Word Help 3 March 22nd 05 04:24 PM


All times are GMT +1. The time now is 05:07 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"