Re: Mail Merge Issue

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Dan,

I'm merging data from a "lookup" column from Access. The number comes
up in the Word output instead of the adjecent text.

How do I make the text come up?

<Sigh> the problems that making the database "user friendly" causes...

You may need to go to an Access newsgroup if you can't follow what I'm
going to tell you. A Word group isn't really the right place to go into
the basics of relational databases, and it's been a while since I had to
explain these.

Word's mail merge can link only to the underlying data in the database,
not to what the database UI is showing you. The "look-up" is a shortcut
Access has created for you, the human, to show you something you're more
likely to be able to relate to than an ID value. But this is not really
stored in the table to which Word is connecting.

What you need is a QUERY that does what Access is doing for you in the
background. Mail Merge can link to the query, instead of a table, and
pull in the information that way.

So, you go into the Query Designer and add the table you want to merge
to, plus the table(s) that contain the information the look-up is pulling
in. Since Access is able to do the look-up, all the links should come in
automatically. Then just pull the fields you need for the mail merge into
the Query grid (the "text" instead of the "ID", for example, from the
underlying table).

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 :-)

.

Relevant Pages

  • Re: Data Updating queries
    ... You might want to ask your question in an Access newsgroup. ... then use another tab for another data set of the sheet. ... Similar to relation database table structuring. ... Is there a simple query against a sheet with many cells width that I ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Union Query with joins
    ... Sorry but I did not post to an access newsgroup because I do not wish to do ... section of the Union, not just at the end like ORDER BY. ... into one query if possible. ... Each query in the union can have its own WHERE, GROUP BY, or HAVING clauses ...
    (microsoft.public.vb.syntax)
  • Passing parameters via ASP/Vscript
    ... BlankI sent the post below to an Access newsgroup, but I think it may a ... vbscript problem. ... guestbook.asp which reads the entire database and has the line at the ... Microsoft JET Database Engine error '80040e14' ...
    (microsoft.public.scripting.vbscript)
  • Re: Error in Mail Merge with MS Access - cant find data source
    ... you would be better off to ask in an Access newsgroup. ... Doug Robbins - Word MVP ... The first error is "Can't find visible tables". ... I use to options button I can see the query but then when I try to merge ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Newbie: Why dont I have Security on one of my drives?
    ... Access newsgroup can help with your problem. ... If I go in and do any work on the database ... Lose of the Internet User permission. ... > Larry Woods ...
    (microsoft.public.sqlserver.security)