This is very helpful. I was wondering if you have similar information
on
E-mail Merges instead of Directory Merges? I got your recommendations
to
work using Directory, but I would like to send emails with multiple
rows of
data. Thanks!
:
Hi mom2dramaqeen,
No need to get snippy
No need to be a drama queen either!
The 'key' field to which the tutorial field refers is whatever field
in your mailmerge data source you choose to nominate as the
one
to which changes in data groupings are 'keyed'. The tutorial says as
much.
QUOTE:
The 'Key' Field
Before using this type of mailmerge, you'll need to determine which of
the data fields you want to use as the one to trigger the
separation of the lists. This is your 'key' field. You should then
sort your data file so that all the records with the same 'key'
field value are grouped together. The accompanying Excel data file is
sorted by the 'State' field, then the 'City' field and,
finally, the 'Representative' field.
If you view the field code for the first example in the tutorial,
you'll see:
{QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD City}<> {Key}
"{IF{MERGESEQ}> 1 "
"}{MERGEFIELD State} {MERGEFIELD City}{SET Key {MERGEFIELD City}}
" } {MERGEFIELD Representative} {MERGEFIELD Sales}
"}
In this field construction, the 'City' data field is used as the
'Key', and the the State & City names are only output when the
City
name changes.
--
Cheers
macropod
[MVP - Microsoft Word]
message
No need to get snippy, the articles talk about a "key" field and
since I have
no clue at all about what the article is talking about. I
understand how to
show toggle field, I know how to do that, but I cannot get it to
work and I
don't understand what you mean. I need more basic information then
what that
article says.
Sorry, I just don't get the article you keep posting and need more
indepth
info.
:
Have you followed this part of Macropods instructions:
To view the fields in this document, I recommended (sic) that you
toggle
field shading on. You can do this via Tools|Options|View and, under
'Show',
selecting the 'Always' or 'When selected' options. You'll probably
find the
'Always' option works best. Doing this has no effect on the printed
output
but makes the fields easier to work with on-screen.
To see the inner workings of any field, select it and press
Shift-F9. When
you're done, pressing Shift-F9 again will toggle the display back
to showing
the field's results. Alternatively, if you press F9, the field will
update
and toggle the display back to showing the field's results in one
go.
The only place that you have to "mark something as a "key" field"
is in your
mind.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of
my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
message
And if I bookmark the "key" then how exactly do I tell the fields
to look
at
it? I don't have a clue, that's why your document is over my
head and I
need
more basic guidance. Once I know this part then I'm probably
fine with
the
rest, but I've never done this before but have a huge need to
learn.
:
That's the thing. I've read your documents, and it makes no
sense to me
what
I'm suppose to do.
I have no clue how to mark something as a "key" field. I know
which one
I
want to sort by, but I have no clue how to tell it that. I'm
looking at
your
page 3 and I cannot even get the example you give to produce a
sorted
list
like you have becuase I don't know how to tell the system this
is the
key.
Am I to Bookmark the field, if so how?
:
Hi mom2dramaqeen,
The process is fully explained in my my Word 97-2007
Catalogue/Directory Mailmerge Tutorial at:
http://www.wopr.com/index.php?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial (especially the Introduction) before
trying to use
the mailmerge document included with it.
--
Cheers
macropod
[MVP - Microsoft Word]
"mom2dramaqeen" <
[email protected]>
wrote in
message
I've read the other post on this and I'm still lost.
I have a file sorted by a "key" code that I want to send an
email
mail merge
and have all "rows" from my data source that have this same
"key" on
that one
email, before the next email is made.
I've read the articles posted and I'm completely confused.
I don't
know how
in my document to mark my "key" field as a the key. I don't
understand how
to or where at in my main document to do this.
Can someone help me and be more specific.
here is an example of what I'm working with:
Key Fname Lname Salary
001-090 Joe Smith 20,000
001-090 Suzie Smith 15,000
001-091 Bob James 20,000
002-090 Jan Jones 20,000
This data is in excel, I know how to create a normal main
document
and
connect to my data source. My data source is sorted by the
key. I
want my
document to have a letter type formate containing generic
informaiton
with a
table of the people who have the problem. So for example
001-090
should have
two rows in the table One for Joe and then another line for
Suzie,
but
001-091 would only have one.
Please help.
