On 5/17/02 10:41 PM, "Jan Martel" <[EMAIL PROTECTED]> wrote:
> On 5/17/02 9:31 PM, "Paul Berkowitz" wrote: > >> You were too impatient. if you do a Data Merge creating Catalog, the, at the >> bottom, press Query Options. You will be able to select by category, by >> specific selection of contacts, or both together. (This is only in Word X - >> in 2001, use my much cruder Address Book List script.) > > OK, this is better (I didn't realize Query Options worked this way; I've > used data merge before with Excel docs). But I still can't select the > flagged contacts (obviously, I could create another category instead of > using flags, but the flags worked well in Custom View). And, more important, > it doesn't seem to sort in any rational order (I can't figure out how it has > sorted; maybe by the order in which I entered the contacts?). Also, when I > tried to insert tabs (in the document made by merging), it acted very > strangely - kept removing the ruler so I couldn�t add more tabs. I > eventually got the spacing I wanted, and I can obviously use a header to > have column headings, but that was when I noticed the weird sorting and > decided to call it quits for the night. Oh, and it also doesn't offer both > home and work phone numbers, which I have in my custom view - just "phone" > which I'm assuming is the phone number associated with the default address, > and "mobile phone." You're right about the ordering. Weird. It must be by ID which is effectively by the date they were added to the Address Book, as you say. Try this: Tab once between each field as you enter the fields. Don't worry about the spacing now. No other punctuation unless you want items to be part of the same field (so no tabs, just comma and space between street address zip, state). Only ONE carriage return at the end of the fields. Do the merge. When it finishes, press command-A to select All. Now go to Table menu, select Convert --> Text to Table. You'll see that it calculates as many columns as your tabs (fields), and as many rows as your CRs (lines). Make sure that it has Tabs selected as separator. Click AutoFormat and pick a nice format. *** Uncheck the boxes a the bottom for Header row and First column as special. Click OK. Now, with the whole table still selected (or command-A again), go to Table--> Sort. Put Column 2 (or whatever column has Last Name) as first sort, and Column 1 (or whatever column has First Name) as second sort. Click OK. Because of the secondary sort, you might have to select all and do another AutoFormat if you chose a format such as Contemporary which alternates light and dark shading. Now you have a beautifully formatted table, sorted as you like, all ready to print. Print. -- Paul Berkowitz MVP Entourage -- To unsubscribe: <mailto:[EMAIL PROTECTED]> archives: <http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/> old-archive: <http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
