Hello, I am trying to make labels for a mass mailing my company would like to do and I am encountering a problem I don't understand. For background, I have made labels before using Office/Excel 2007 on a windows and now I am using Office/Excel 2011 on a mac. Nuget support does not work with visual studio for mac. So I made my excel sheet with four columns for First Name, Last Name, Address and City/State/Zip Code.

I have the top row labeled as such. I don't know if I need to do anything else, normally I would have to select the data and create a group for them, but when I try to do the same thing now by hitting Group under the Data Tab it asks if I want to do it by rows or columns, I choose columns and then it makes a grey little bar appear over the columns, but it doesn't ask me to give the data a name or anything. So I saved it (.xlsx) and started mail merge manager in Word.

When I choose get list - open data source and select my.xlsx file with the saved data, it brings up a Convert File box which asks 'Convert File From:' and then has a bunch of selections to choose from. It always wants to do unicode text, but if I choose that one its just a mass of random symbols. I've tried every single conversion including Excel Workbook, which is what the file is, and it either gives me 'There was an error opening the file'. It seems to me that for some reason Microsoft Word 2011 for Mac can't read Excel 2011 for Mac files, which makes no sense. If you could help that would be great, and any walkthrough that exists for creating labels that is for Microsoft Office 2011 for Mac and INCLUDES how to create the Excel spreadsheet would help. Thanks, Erik Peterson. Hello, I am trying to make labels for a mass mailing my company would like to do and I am encountering a problem I don't understand.

Excel For Mac 2011 Training

For background, I have made labels before using Office/Excel 2007 on a windows and now I am using Office/Excel 2011 on a mac. So I made my excel sheet with four columns for First Name, Last Name, Address and City/State/Zip Code. I have the top row labeled as such. I don't know if I need to do anything else, normally I would have to select the data and create a group for them, but when I try to do the same thing now by hitting Group under the Data Tab it asks if I want to do it by rows or columns, I choose columns and then it makes a grey little bar appear over the columns, but it doesn't ask me to give the data a name or anything.

Excel Download For Mac Free

So I saved it (.xlsx) and started mail merge manager in Word. When I choose get list - open data source and select my.xlsx file with the saved data, it brings up a Convert File box which asks 'Convert File From:' and then has a bunch of selections to choose from. It always wants to do unicode text, but if I choose that one its just a mass of random symbols. I've tried every single conversion including Excel Workbook, which is what the file is, and it either gives me 'There was an error opening the file'. I have also tried saving the excel file as.xls and it could not read it either.

It can read.CSV, but when input placeholders, it only imputs the first row of the data, the First Name, Last Name, Address, and City/State/Zip Code row and updates that for every label, it doesn't imput any of the actual data. It seems to me that for some reason Microsoft Word 2011 for Mac can't read Excel 2011 for Mac files, which makes no sense. If you could help that would be great, and any walkthrough that exists for creating labels that is for Microsoft Office 2011 for Mac and INCLUDES how to create the Excel spreadsheet would help. Thanks, Erik Peterson. Make sure you have Office 2011 fully updated - 14.2.3 is the current build. Once the update level is confirmed run Disk Utility to repair disk permissions. Confirm that the name of the Excel file, the names of the folders containing it & the name of the drive do not contain any illegal characters.

Read Only Excel 2011 Mac

Right-click an Excel file in Finder, select Get Info then make sure to choose Excel in the Open With section & click the Change All button. Restart your Mac If the problem continues, see this additional ANSWER: Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.

Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only.

Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.