Address Labels

H

HAL KUSHNER

How do you print selected address labels from Entourage address book in
Entourage-Word? I¹m running a G-5 IMAC with MS Office/Mac 2004 Version
11.2.1?

Thanks/Hal
 
M

Michel Bintener

You'll need a feature called Data Merge Manager. In Word's Help, search for
"create labels by using the data merge manager", and you'll get a
step-by-step tutorial on how to do this. If anything's unclear, post back.

Michel
 
M

Michel Bintener

You accidentally sent your reply to my email account, so I'll paste it in
here. Anyway, here's a few tips: use the instructions from Word Help, as I
told you. You'll end up with a page that presumably contains lots of table
cells with entries that look like "«First_Name» «Last_Name»
«Address»". You've selected the Office Address Book as your data source, and
since you only want to print a few specific addresses, you'll have to use
query options. On the Data Merge palette, expand the Merge pane, if it isn't
already. Click on Query Options, and in that new dialogue, use the dropdown
list at the very top to list mail merge recipients by "complete record".
You'll now see your entire address book, with checkboxes in front of each
contact. Since you only want to print ~30, you'd better click on Clear All
in the lower left corner and then individually select the contacts you need.
If you now click on OK and then print the document, you should theoretically
get what you want. If that's not the case, post back. And make sure you hit
"reply to newsgroup" if you do so.

Michel
I read this before I sent the original post[data merge manager]...I want to
create a number of labels (not all of them, inclusive) from my address book
entries. I'm going on a trip and wanted to print about 30 specific and
different labels to address post cards. I found the instructions in Word
and the Merge Manager somewhat ambiguous...and tried to use it, but printed
a page of labels with the same address. Sorry to be so thick...I guess I
need more explicit direction.
-- Cheers

You'll need a feature called Data Merge Manager. In Word's Help, search for
"create labels by using the data merge manager", and you'll get a
step-by-step tutorial on how to do this. If anything's unclear, post back.

Michel
 
H

HAL KUSHNER

Michel Bintener3/5/06 5:45
[email protected]03071E2.12D62%[email protected]
You accidentally sent your reply to my email account, so I'll paste it in
here. Anyway, here's a few tips: use the instructions from Word Help, as I
told you. You'll end up with a page that presumably contains lots of table
cells with entries that look like "«First_Name» «Last_Name»
«Address»". You've selected the Office Address Book as your data source, and
since you only want to print a few specific addresses, you'll have to use
query options. On the Data Merge palette, expand the Merge pane, if it isn't
already. Click on Query Options, and in that new dialogue, use the dropdown
list at the very top to list mail merge recipients by "complete record".
You'll now see your entire address book, with checkboxes in front of each
contact. Since you only want to print ~30, you'd better click on Clear All
in the lower left corner and then individually select the contacts you need.
If you now click on OK and then print the document, you should theoretically
get what you want. If that's not the case, post back. And make sure you hit
"reply to newsgroup" if you do so.

Michel
I read this before I sent the original post[data merge manager]...I want to
create a number of labels (not all of them, inclusive) from my address book
entries. I'm going on a trip and wanted to print about 30 specific and
different labels to address post cards. I found the instructions in Word
and the Merge Manager somewhat ambiguous...and tried to use it, but printed
a page of labels with the same address. Sorry to be so thick...I guess I
need more explicit direction.
-- Cheers

You'll need a feature called Data Merge Manager. In Word's Help, search for
"create labels by using the data merge manager", and you'll get a
step-by-step tutorial on how to do this. If anything's unclear, post back.

Michel


On 04.03.06 23:08, in article C02F8831.194A9%[email protected], "HAL

How do you print selected address labels from Entourage address book in
Entourage-Word? I¹m running a G-5 IMAC with MS Office/Mac 2004 Version
11.2.1?

Thanks/Hal
The 'query options' was the rate limiting step...thanks/hal
 
H

HAL KUSHNER

Query was the rate limiting step...it printed as I wanted but with the
following error. I set up my Avery 8161 labels as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country

It printed as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country>>address>>street
City>>State>>Zip

Now my data base Entourage Address book lists two addresses, home and
business, and the merge manager didn't give me the option of which to
choose. I think it chose the default address and then printed it double in
the manner described above. Any suggestions? Thanks, Hal

Michel Bintener3/5/06 5:45
[email protected]03071E2.12D62%[email protected]
You accidentally sent your reply to my email account, so I'll paste it in
here. Anyway, here's a few tips: use the instructions from Word Help, as I
told you. You'll end up with a page that presumably contains lots of table
cells with entries that look like "«First_Name» «Last_Name»
«Address»". You've selected the Office Address Book as your data source, and
since you only want to print a few specific addresses, you'll have to use
query options. On the Data Merge palette, expand the Merge pane, if it isn't
already. Click on Query Options, and in that new dialogue, use the dropdown
list at the very top to list mail merge recipients by "complete record".
You'll now see your entire address book, with checkboxes in front of each
contact. Since you only want to print ~30, you'd better click on Clear All
in the lower left corner and then individually select the contacts you need.
If you now click on OK and then print the document, you should theoretically
get what you want. If that's not the case, post back. And make sure you hit
"reply to newsgroup" if you do so.

Michel
I read this before I sent the original post[data merge manager]...I want to
create a number of labels (not all of them, inclusive) from my address book
entries. I'm going on a trip and wanted to print about 30 specific and
different labels to address post cards. I found the instructions in Word
and the Merge Manager somewhat ambiguous...and tried to use it, but printed
a page of labels with the same address. Sorry to be so thick...I guess I
need more explicit direction.
-- Cheers

You'll need a feature called Data Merge Manager. In Word's Help, search for
"create labels by using the data merge manager", and you'll get a
step-by-step tutorial on how to do this. If anything's unclear, post back.

Michel


On 04.03.06 23:08, in article C02F8831.194A9%[email protected], "HAL

How do you print selected address labels from Entourage address book in
Entourage-Word? I¹m running a G-5 IMAC with MS Office/Mac 2004 Version
11.2.1?

Thanks/Hal
 
H

HAL KUSHNER

Query was the rate limiting step...it printed as I wanted but with the
following error. I set up my Avery 8161 labels as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country

It printed as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country>>address>>street
City>>State>>Zip

Now my data base Entourage Address book lists two addresses, home and
business, and the merge manager didn't give me the option of which to
choose. I think it chose the default address and then printed it double in
the manner described above. Any suggestions? Thanks, Hal

Michel Bintener3/5/06 5:45
[email protected]03071E2.12D62%[email protected]
You accidentally sent your reply to my email account, so I'll paste it in
here. Anyway, here's a few tips: use the instructions from Word Help, as I
told you. You'll end up with a page that presumably contains lots of table
cells with entries that look like "«First_Name» «Last_Name»
«Address»". You've selected the Office Address Book as your data source, and
since you only want to print a few specific addresses, you'll have to use
query options. On the Data Merge palette, expand the Merge pane, if it isn't
already. Click on Query Options, and in that new dialogue, use the dropdown
list at the very top to list mail merge recipients by "complete record".
You'll now see your entire address book, with checkboxes in front of each
contact. Since you only want to print ~30, you'd better click on Clear All
in the lower left corner and then individually select the contacts you need.
If you now click on OK and then print the document, you should theoretically
get what you want. If that's not the case, post back. And make sure you hit
"reply to newsgroup" if you do so.

Michel
I read this before I sent the original post[data merge manager]...I want to
create a number of labels (not all of them, inclusive) from my address book
entries. I'm going on a trip and wanted to print about 30 specific and
different labels to address post cards. I found the instructions in Word
and the Merge Manager somewhat ambiguous...and tried to use it, but printed
a page of labels with the same address. Sorry to be so thick...I guess I
need more explicit direction.
-- Cheers

You'll need a feature called Data Merge Manager. In Word's Help, search for
"create labels by using the data merge manager", and you'll get a
step-by-step tutorial on how to do this. If anything's unclear, post back.

Michel


On 04.03.06 23:08, in article C02F8831.194A9%[email protected], "HAL

How do you print selected address labels from Entourage address book in
Entourage-Word? I¹m running a G-5 IMAC with MS Office/Mac 2004 Version
11.2.1?

Thanks/Hal
 
M

Michel Bintener

Hi Hal,

I should specify that I'm not really an expert on data merging, as I've
never had to use this feature. The things I've been telling you are what
I've come across by experimenting a bit with Word, so I can't tell you how
you can select anything other than the default address from the Office
Address Book.

Now, for your other question: the field "Address" covers the entire address,
including street, city, state, zip and country. Try using only the "Address"
field and ignore all the other, more specific labels, and see if the result
is closer to want you'd want it to be.

As I've just said, I don't know if it's possible to select a non-default
address from the Office Address Book, so maybe someone else will be able to
help you out on this problem.

Michel


Query was the rate limiting step...it printed as I wanted but with the
following error. I set up my Avery 8161 labels as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country

It printed as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country>>address>>street
City>>State>>Zip

Now my data base Entourage Address book lists two addresses, home and
business, and the merge manager didn't give me the option of which to
choose. I think it chose the default address and then printed it double in
the manner described above. Any suggestions? Thanks, Hal

Michel Bintener3/5/06 5:45
[email protected]03071E2.12D62%[email protected]
You accidentally sent your reply to my email account, so I'll paste it in
here. Anyway, here's a few tips: use the instructions from Word Help, as I
told you. You'll end up with a page that presumably contains lots of table
cells with entries that look like "«First_Name» «Last_Name»
«Address»". You've selected the Office Address Book as your data source, and
since you only want to print a few specific addresses, you'll have to use
query options. On the Data Merge palette, expand the Merge pane, if it isn't
already. Click on Query Options, and in that new dialogue, use the dropdown
list at the very top to list mail merge recipients by "complete record".
You'll now see your entire address book, with checkboxes in front of each
contact. Since you only want to print ~30, you'd better click on Clear All
in the lower left corner and then individually select the contacts you need.
If you now click on OK and then print the document, you should theoretically
get what you want. If that's not the case, post back. And make sure you hit
"reply to newsgroup" if you do so.

Michel
I read this before I sent the original post[data merge manager]...I want to
create a number of labels (not all of them, inclusive) from my address book
entries. I'm going on a trip and wanted to print about 30 specific and
different labels to address post cards. I found the instructions in Word
and the Merge Manager somewhat ambiguous...and tried to use it, but printed
a page of labels with the same address. Sorry to be so thick...I guess I
need more explicit direction.
-- Cheers

On 05.03.06 0:05, in article C02FDBCD.12D3D%[email protected], "Michel

You'll need a feature called Data Merge Manager. In Word's Help, search for
"create labels by using the data merge manager", and you'll get a
step-by-step tutorial on how to do this. If anything's unclear, post back.

Michel


On 04.03.06 23:08, in article C02F8831.194A9%[email protected], "HAL

How do you print selected address labels from Entourage address book in
Entourage-Word? I¹m running a G-5 IMAC with MS Office/Mac 2004 Version
11.2.1?

Thanks/Hal
 
H

HAL KUSHNER

Michel Bintener3/5/06 8:36
[email protected]03099D9.12D6D%[email protected]
Hi Hal,

I should specify that I'm not really an expert on data merging, as I've
never had to use this feature. The things I've been telling you are what
I've come across by experimenting a bit with Word, so I can't tell you how
you can select anything other than the default address from the Office
Address Book.

Now, for your other question: the field "Address" covers the entire address,
including street, city, state, zip and country. Try using only the "Address"
field and ignore all the other, more specific labels, and see if the result
is closer to want you'd want it to be.

As I've just said, I don't know if it's possible to select a non-default
address from the Office Address Book, so maybe someone else will be able to
help you out on this problem.

Michel


Query was the rate limiting step...it printed as I wanted but with the
following error. I set up my Avery 8161 labels as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country

It printed as follows:

First name>>Last name
Address>>Street
City>>State>>Zip
Country>>address>>street
City>>State>>Zip

Now my data base Entourage Address book lists two addresses, home and
business, and the merge manager didn't give me the option of which to
choose. I think it chose the default address and then printed it double in
the manner described above. Any suggestions? Thanks, Hal

Michel Bintener3/5/06 5:45
[email protected]03071E2.12D62%[email protected]
You accidentally sent your reply to my email account, so I'll paste it in
here. Anyway, here's a few tips: use the instructions from Word Help, as I
told you. You'll end up with a page that presumably contains lots of table
cells with entries that look like "«First_Name» «Last_Name»
«Address»". You've selected the Office Address Book as your data source, and
since you only want to print a few specific addresses, you'll have to use
query options. On the Data Merge palette, expand the Merge pane, if it isn't
already. Click on Query Options, and in that new dialogue, use the dropdown
list at the very top to list mail merge recipients by "complete record".
You'll now see your entire address book, with checkboxes in front of each
contact. Since you only want to print ~30, you'd better click on Clear All
in the lower left corner and then individually select the contacts you need.
If you now click on OK and then print the document, you should theoretically
get what you want. If that's not the case, post back. And make sure you hit
"reply to newsgroup" if you do so.

Michel

I read this before I sent the original post[data merge manager]...I want to
create a number of labels (not all of them, inclusive) from my address book
entries. I'm going on a trip and wanted to print about 30 specific and
different labels to address post cards. I found the instructions in Word
and the Merge Manager somewhat ambiguous...and tried to use it, but printed
a page of labels with the same address. Sorry to be so thick...I guess I
need more explicit direction.
-- Cheers

On 05.03.06 0:05, in article C02FDBCD.12D3D%[email protected], "Michel

You'll need a feature called Data Merge Manager. In Word's Help, search
for
"create labels by using the data merge manager", and you'll get a
step-by-step tutorial on how to do this. If anything's unclear, post back.

Michel


On 04.03.06 23:08, in article C02F8831.194A9%[email protected], "HAL

How do you print selected address labels from Entourage address book in
Entourage-Word? I¹m running a G-5 IMAC with MS Office/Mac 2004 Version
11.2.1?

Thanks/Hal
You were right...before I received this, I substituted only 'address'
neglecting the specifics of street, etc...and got what I wanted. Also a
short cut is to designate those addressees whom one wants on the merged
document in a specific category [I chose 'labels'] and then merge the data
with the 'label' category only. Everything worked perfectly...I saved the
label document in a folder, so can now print at will on the next trip.
Thanks to you...I find that most "Help" topics in MS apps have a problem
with the ambiguity of the antecedent of the relative pronoun. Precision in
syntax and grammar is sometimes lacking. These newsgroups are invaluable.
Thanks again.
 
Top