Re: Address Labels by HAL
HAL
Sun Mar 05 08:51:47 CST 2006
Michel Bintener3/5/06 8:36
AMm_bintener@hotmail.comC03099D9.12D6D%m_bintener@hotmail.com
> 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
>
>
> On 05.03.06 13:21, in article C030500F.1951C%halkfl@cfl.rr.com, "HAL
> KUSHNER" <halkfl@cfl.rr.com> wrote:
>
>> 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
>> AMm_bintener@hotmail.comC03071E2.12D62%m_bintener@hotmail.com
>>
>>> 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%m_bintener@hotmail.com, "Michel
>>>> Bintener" <m_bintener@hotmail.com> wrote:
>>>>
>>>>> 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%halkfl@cfl.rr.com, "HAL
>>>>> KUSHNER" <halkfl@cfl.rr.com> wrote:
>>>>>
>>>>>> 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.