Mail Merge Wizard pulls Contact List not the specified Excel file-Help

[patriciaanne]

Hi- I exported my Outlook Contact list to Excel and filtered it. I saved the new file. When I use the Mail Merge Wizard in Word, it allows me to select the excel file as the recepient file but then displays a dialog box showing three different Contact tables. No matter which I select, I always end up with all the Contacts from Outlook. I also tried it with an Excel file that wasn't filtered and same results. Any idea where I am going wrong?
Patricia

 

[Dreamboat]

What are you mail-merging to?

New Document
Printer
Address book

Make sure it's New Document...

Anne Troy

http://www.VBAExpress.com

 

[mosmas]

patriciaanne:

Save your excel file as csv file and try it. Or, if you are using the wizard, go back to step 3 and Select a different list and reselect the file once again.

If that fails, I would do a Detect and Repair on Word. Hope this helps. Good luck to you. God bless.

mosmas