> 1. I have a datafile in Excel which includes all clients. However, they
> do
[quoted text clipped - 3 lines]
> [field]
> = "not blank"). Now the process seems much more complicated.
It is, but you can still get to the Query Options by clicking on the tiny
drop-down arrow in one of the headings of the columns in Select Recipients,
and choosing Advanced... You can also go into Tools|Customize|Commands,
select Category All COmmands, and locate and drag MailMergeHelper out to a
toolbar (in fact I would recommend that you enable the Mail Merge Toolbar in
Word 2003, which stays enabled all the time unlike the old one) and put it
there. Click that and you should see the old query options. However, you may
find some of the filtering does not work as expected in this version, unless
you change the connection method to Excel...
> 2. It also doesn't seem to let me edit the data source from that point,
> which you could before - there is an edit button, it is never active.
In essence, this button is disabled for many types of data source now. For
Excel, you may be better off reverting to the old way Word connected to
Excel - check Word Tools|Options|General|"Confirm conversion at open", go
through the connection process again, and select the DDE option when it is
offered. I think you will probably need to edit inside the copy of Excel
that Word starts in that case. But that is also the approach most likely to
fix your point (3). The new approach is that the formatting you specified in
Excel is lost in the transfer and you have to put numeric format switches
into your numeric merge fields in Word, e.g. something like
{ MERGEFIELD myamount \#"$,0.00" } for a dollar amount
Peter Jamieson
> We have just been upgraded at work to Office 2003 from Office 97 (no
> training
[quoted text clipped - 29 lines]
>
> Thank you.