[mso] Re: word - How to see which adresses have been used in mailmerge
- From: MCS - Franz-Robert van Vugt <zeno@xxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 20 Nov 2004 15:36:39 +0100
Thanks for the Advice!
It was a great help!
I have only one question left..
Is there a way to automatically insert a value in the SENT column when
sending/merging/printing .. ? So that we don't need to worry about
manually inserting these values ..
Thanks in advance!
Franz-Robert
-----Oorspronkelijk bericht-----
Van: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] Namens
Linda F. Johnson
Verzonden: vrijdag 15 oktober 2004 16:06
Aan: mso@xxxxxxxxxxxxx
Onderwerp: [mso] Re: word - How to see which adresses have been used in
mailmerge
Urgentie: Hoog
Which version of Word are you using?
If it's Word 97 or 2000, at the bottom of the mail merge window you see
a
button beside the Merge button that says "Query Options". Click on
that
and you can click on the Filter Options tab in there and choose the
field
you created in Access and make it " not egual to" whatever value you put
in
the records for the ones that have already been sent.
If you are using Word 2002 or 2003, to get to this box, go to Step 3 of
the
Mail Merge. Then click on "Edit Recipient List" in your Task Pane. You
will see dropdown arrows at the top of each column. Click on any arrow
and
choose "Advanced")
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV. If you got a bug that looks
like
it came from me, it did NOT!
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf
Of Franz-Robert van Vugt
Sent: Thursday, October 14, 2004 9:11 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] word - How to see which adresses have been used in
mailmerge
Hello to all!
Does anyone now how you can store the adresses used in a mailmerge?
I have a access database, where I get my addresses from. I made a mail
merge in word. So now I am able to select multiple addresses and make
word merge them. I would like to store the addresses, so I can see whom
I sent a (snail!) mail already. The way I think is best, is to creat an
extra column in the access table, saying which ID has already been
mailed.. and somehow not display the already mailed ones in word. The
question is, how can I do a query or something like that in word, so
that this information will be stored in the database?
I hope this explanation of my problem is clear enough..
Thanks in advance!
Kind regards,
Franz-Robert van Vugt
*************************************************************
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
*************************************************************
*************************************************************
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
*************************************************************
*************************************************************
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:
