View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2007 - mail merge filter not displaying unique choices

I am not sure what is going on there because when I create such a datasource
(*.xslx) and attach it to a mail merge main document and then click on the
State pulldown, I see

Sort Ascending
Sord Descending
(All)
(CA)
(VA)
(NY)
etc.
(Blanks)
(Nonblanks)
(Advanced...)

If you want to send me a copy of the data source, I will take a look and see
if I can see what is causing the problem.

--
Hope this helps

Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to avail yourself of my
services on a paid, professional basis.

"Tammy" wrote in message
...
Hi - I am trying to do an email mail merge through Word 2007. My data
source
is an Excel file.

I'd like to filter the list of recipients so that only a specific group
receives the email - pretty easy stuff. The problem is that, in the Mail
Merge Recipients dialog box, when I click the column heading down arrow to
choose what I'd like to filter, there are no choices. I can see the usual
choices of: All, Blanks, Nonblanks, and Advanced - just not the values
from
the column in the Excel file. The column does contain different data (for
example - the states of NY, NH, CT, etc), just not sure why I can't see
them
in the list to filter. I hope I have explained that well enough - any
suggestions on why Word would not display the choices? Thanks so much!