Merge it with microsoft word

[Guest]

For some reason when i do the "directory" merge it throws my recepient list
out of alphabetical order. I've tried doing it five times and every time i
look at the recepient list right before processing the merge it is always out
of order and i don't want to have to spend hours cut and pasting the names to
put them back in order. Any suggestions. I am using Access version 2002 and
word 2002. My end product is a html document a list of designers name
address, title, new line company name, city, state, zip, new line work phone,
fax, new line email, new line web address. It works but the list is not
alphabetized....in word after the merge it becomes many pages and it semi
alphabetizes a to z on each page. I need it to alphabetize a starting on
page 1 and z ending on the last page. In access the document is in
alphabetical order.

 

[Joseph Meehan]

For some reason when i do the "directory" merge it throws my
recepient list out of alphabetical order. I've tried doing it five
times and every time i look at the recepient list right before
processing the merge it is always out of order and i don't want to
have to spend hours cut and pasting the names to put them back in
order. Any suggestions. I am using Access version 2002 and word
2002. My end product is a html document a list of designers name
address, title, new line company name, city, state, zip, new line
work phone, fax, new line email, new line web address. It works but
the list is not alphabetized....in word after the merge it becomes
many pages and it semi alphabetizes a to z on each page. I need it
to alphabetize a starting on page 1 and z ending on the last page.
In access the document is in alphabetical order.

How is the list alphabetized now? Are you relying on the order that
they appear in the table? No good. You need to add a process along the way
to put then in order. I suggest a query. Then base the the rest of the
process now based on the table on the query.

 

[Larry Daugherty]

Hi Debbie,

Create a query in Access that sorts it the way you want. Then base your
merge on the Query, not on the underlying table.

HTH