Mail Merge Error opening data source file

Using Office for Mac 2011 for first time. When trying a mail merge, try to open data source (xls. file) and it asks what converter to use. I choose Excel 97-2004 workbook, say "ok" that it is a trusted source, and then get message that there was an error opening file. I've tried creating new test files in excel in case the original Windows file was the problem. No luck. Help!
 

Question Info


Last updated April 3, 2019 Views 9,625 Applies to:
Answer
Answer

1. Select "Go" and hold option key -> select "library" (This will navigate to your user library folder)

2. Go to -> Preferences -> create a folder over here by the name "Microsoft"

 

Try using the mail merge now.

 

Thanks,

Bull's Eye

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
Answer

I'll stick my Neck out on this Old thread here are the steps:

  1. From Finder (screen you see when when you first open computer or restart computer).
  2. Hold down Option/Alt key while clicking on Go menu.
  3. You should see a choice called Library - see:
  4. I have highlighted in green the library folder in question. 
  5. Click on Library and go from there. 
If my reply has helped, mark accordingly - Helpful or Answer
Phillip M. Jones, C.E.T.

6 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.