[mso] Re: word 2000 mail labels
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 28 Nov 2004 13:34:26 +0100
Yup... Last name it is.
I thought the sorting was done before the data got to word though
Linda. Actually... after experimenting a bit... I can sort on a field
using the query options ummmm.. option. The *but* though, seems to be
only from a *table* rather than a query. It's strange becuse the query
sorts by last name but the data doesn't come out sorted in the merge!
This is for a client who wants to use word for the mail merge because
he feels comfortable with it. I have a few people the same in fact. I
think it's about being a bit intimidated by a "database", whereas a
word processor is perhaps more accessible and immediate. Dunno. I have
one person who opens word up in the morning and only closes it down
when she goes home! Even moves and copies files from word!
Anyway... thanks for the answer.
Lisa
> Hey Lisa....since I know you use Access a lot, I'm curious
> why you don't
> just leave the data in Access and use Access's Label
> Wizard? That will let
> you sort just like any other report.
>
> Maybe Access 2000 doesn't have the label wizard? I can't
> remember, but I
> know it's in 2002 and 2003 (New Object button>Report>Label Wizard)
>
> The problem in Word is the name, address, etc. are all in
> one table cell so
> you can only sort by what's the first thing in the cell,
> which could be a
> first name, could be "Mr.", could be anything, but I'm
> assuming you want to
> sort them by last name?
>
>
> Linda
> Linda's Computer Stop
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
