Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Kelley Kelley is offline
external usenet poster
 
Posts: 9
Default Word Mail Merge not picking up filtered data from Excel

Word 2007, Excel 2007, XP

I am trying to use Mail Merge in Word (envelopes) from a large Excel
spreadsheet. The Excel spreadsheet has several columns that have been
filtered. I turn the filter off before saving the spreadsheet (saving the
filtered information). When I merge, ALL the information on the spreadsheet
is coming over - which rather defeats the purpose of filtering the
spreadsheet in the first place.

I can copy the filtered spreadsheet onto a new spreadsheet and then the
merge seems to work, but should I have to do this?

Any ideas? Thanks.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Filtered Excel Data LFP Mailmerge 1 January 28th 09 10:01 PM
Excel Data Filtered for Unique records George Mailmerge 6 January 14th 09 08:53 PM
Mail Merge Not Picking All Up data Janet A. Thompson Mailmerge 5 December 8th 08 08:40 PM
Why doesn't mail merge show filtered excel worksheets REVA Mailmerge 1 January 24th 06 03:30 PM
How do I do mail merge using filtered data from excel REVA Mailmerge 3 January 24th 06 03:30 PM


All times are GMT +1. The time now is 08:18 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"