Re: A script for merging each first name of group to email

[zaqq]

Title: Re: A script for merging each first name of group to email

Wow! That is brilliant! Thank you so much, Paul! What a cool, cool feature. I’d given up on mail merges way back in Word 6, after many muck-ups, and hadn’t touched it since. But that tip about the “Query” button was the answer. It shows you all the categories. This is going to make my emails to numerous people so much better. I even was able to ask if the “following street address was correct”, by merging the individual addresses.

One tip for anyone trying this mail merge the first time: turn off your Send & Receive All schedule first! Once you click that final OK button, you watch how the Outbox fills up with a ton of emails. First time I did that, I saw that I hadn’t selected a correct field, and in the midst of changing it, the auto-send started to mail them all. My yell scared the cat in the next room.

Thanks again for showing me how this feature works. Just awesome.

zaqq

> From: "Entourage:mac Talk" <[EMAIL PROTECTED]>
> Date: Mon, 21 Jul 2003 20:00:01 -0700
> To: "Entourage:mac Talk" <[EMAIL PROTECTED]>
> Subject: Entourage-Talk Digest - 07/21/03
>
>> Thanks for the quick reply, Dan. Yes, I do have the whole Office X. I spent
>> most of this morning trying to figure out the Data Merge Manager. I created
>> a Word document of the text that I wanted to email these folks. I opened up
>> the Data Merge Manager. In the "Get Data" button, I chose "Office Address
>> Book", but it tries to import all 2400 names. I then tried to export only a
>> subset of the Address book (just those associated with the category I'm
>> trying to merge with), but it kept exporting all 2400 again.
>>
>> I think the key with this is being able to export just the "first name" of
>> these 50 Entourage contacts, into a tab-delimited file. I think the Data
>> Merge Manager could then be pointed to that file.
>
> When you get to the bottom of the Data Merge manager, you will find a Query
> button. That lets you select one or more categories to merge, and also add
> or remove individual contacts. You must pick Office Address Book as the data
> Source first, of course.--
> Paul Berkowitz