NEW USER needs to extract name and insert in letter after 'Dear'

[hwhitney@cancergenetics]

Added more detail to my original posting

In the access queries I created each column holds data like
FirstName LastName Title.
In the Mail Merge Label documents I created, each box/label
has fields specific to the user. Like an address label.

I have figured out how to create a table and I even
populated it with a names I took from an Access queurie
using Mail Merge Wizard. The problems I have are two.

1 - When the layout is carried forward and all the letters
tables after 'Dear' are populated with names, I see that
the sorting I did in in the querie, and in Mail Merge
Wizard has been ignored. I have every name, included those
I do not want.

2 - Dragging the table to where I want it on the page
(after 'Dear') is way more difficult than it should be.

Looking forward to responses!


Any tips/walks thru How To would be appreciated! Thank
you

 

[Peter Jamieson]

Can you try to spell out what data you have and where you want it to go in
the ouput from your merge? It sounds to me as if you are trying to do a
merge using one data source , and are perhaps inserting a Database field or
something in order to do something like

Dear <<person>>

Here is a list of people assigned to you

<table containing one row per person assigned to the <<person>> >

If so, you will need to modify the WHERE clause in the query in the DATABASE
field so it filters on <<person>>.

But I'm just guessing at the moment.