Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac

Im trying to make labels in Word 2008 using an excel file

Customer Question
I'm trying to make labels...
I'm trying to make labels in Word 2008 using an excel file as the source document. Everytime I select the excel file in Mail merge though, I get an error message that says I don't have the excel workbook text converter. Any ideas how I get that?
Submitted: 5 years ago.Category: Mac
Show More
Show Less
Ask Your Own Mac Question
Answered in 13 minutes by:
12/9/2011
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified

Would you be able to send me the excel file so I can check it. To do so go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.

 

If the file has sensitive information let me know before you upload it

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
I'm not comfortable sending it. Its full of private addresses. Besides - it worked last year with another word program. It seems to be a problem with my Word not excel.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago
You can password XXXXX the file before sending it
Ask Your Own Mac Question
Customer reply replied 5 years ago
Its not a problem with the excel file. Its a problem with Word or with my Excel. I've used Mail merge before. When I select the file I get the following message from Word:

"This file needs to be opened by the Excel Workbook text Converter, which may pose a security risk if the file you are opening is a malicious file. Choose OK to open this file only if you are sure it is a trusted source".

My research shows this is a standard message. I then get a message that says:

"The Converter necessary to open this file cannot be found".

I need to know where to get the converter.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

You do not need a converter if you can open that Excel file. I need the Excel file so I can see what the problem is and set up a Word document to do the mail merge from it

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
ok will try to send now
Customer reply replied 5 years ago
http://wikisend.com/download/252026/Christmas List_120811v2.xlsx

Okay - link is above. Let me know if you can figure it out. I tried it on my mac book as well and got the same error message.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Got the file, thanks. Could you send me the password XXXXX open it

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
It's "mine"
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Ok as I expected there was a problem with the data structure in that Excel file. Here is a sample output after having fixed the file and ran the mail merge on it

 

Attachment: 2011-12-09_193357_christmas_list.docx

 

Let me know if that is ok so I will send you the excel file

 


Thank you for clicking Accept if you are satisfied with the solution

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
I see that you were able to make it work but I don't understand what was wrong with the Excel file. It has worked in the past. Can you explain how you changed it.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Sure I will send you the corrected excel file and include the explanation, in the meantime you can go ahead and click Accept if that solution worked - that is the only way I get credit for helping.

 

Thanks

 

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified
John D and 87 other Mac Specialists are ready to help you
Ask your own question now
Customer reply replied 5 years ago
Okay - I would like to make sure it works on my computer first but I guess I'm going to have to put my faith in you.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Thanks.

 

Ok first download this excel file, and save it to your desktop (before opening it). Then start your mail merge from Word and go to your desktop to select that file. Let me know how it works so I tell you how to fix your own excel files

 

http://www.2shared.com/file/nm3BgGFb/Christmas_List_120811v2_MODIFI.html

 

(make sure to click the blue DOWNLOAD button at the bottom of the download page)

 

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
It didn't' work. Got the exact same error message. Really frustrated right now. Especially as I've already paid.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Can you tell me the exact steps you took from the time you opened the Word document.

 

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
I opened a new blank document. Selected Mail Merge Manager. selected Labels. Next step was to Get List and I selected the modified file from my desk top. I got the same warning as before:

"This file needs to be opened by the Excel Workbook text Converter....etc".

Selected OK.

Got the Same error message as before

"the converter necessary to open this file cannot be found".
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Ok first let me clarify that your original excel file had empty rows in it which could not work as a mail merge file in any Office version. It did not work on my system first until I removed the empty row, then it worked fine

 

Now you seem to have another issue with your Office in addition to the data structure.

 

Could you download this version, close all Word and Excel files, then start Word and do mailmerge on this new file and let me know

 

http://wikisend.com/download/179150/Christmas%20List_120811v2%20MODIFIED%202.xls

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
this created a new issue. When I selected the new modified file it opened a box that said Convert File From: and then offered several different options. First was Text only, etc. I selected Excel Workbook and it didn't work.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

You seem to have a problem with you Office application. Are you able to use mail merge at all? Try using it with any generic or a new excel file and see if it works at all

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
Yes - works with my Address book as the source. Just won't work with Excel.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Were you ever able to do mail merge on an excel file using this system before?

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
No - I've used this excel file with word on another computer. Not with this computer/word
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

First I would like you to test the file that I sent you on another system to make it sure it does work so we can consider that the first issue has been resolved before moving on further

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
Its also doesn't work on my Mac book. As I indicated from the outset - its a problem with my word/office. I have to leave now and won't have access to internet until tomorrow. I need this excel workbook text converter that it keeps referring to.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Ok I will check further and post a reply and you can see it tomorrow when you get back

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
I just tried it on my son's computer. He has a newer version of Word and it worked. Clearly my word.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

It should. Which version does he have?

 

If you want me to create the final mailing labels for you and send them to you in an output word file so you can print it, let me know.

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago
14.1.3 Word 2011. I created the labels on his and sent them to my computer so at least I have a document I can work with.

Would like to know how to fix my word though.
Mac Support Specialist: John D, BS Degree in Engineering replied 5 years ago

Great!

 

There are many draw backs with Office 2008, (among other things it is the only version of Office where standard vba macros cannot run). So I suggest that you upgrade to version 2011 - you won't regret that.

 

Otherwise you can try to fix the current version by first uninstalling Office 2008 (provided you have it on a cd and have the product code to reinstall it). Then create a new user account on your Mac (this should eliminate the possibility that the cause of the problem may be a corruption in your profile) then reinstall Office 2008

 

Hope this helps. Let me know if you have any questions

 

Ask Your Own Mac Question
Ask John D Your Own Question
John D
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Worked on Macs and PC's for 20+ years.

John D is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

< Previous | Next >

Meet the Experts:

Mike

Mike

Mac Medic

8,552 satisfied customers

Over 20 years IT experience with Apple computers in publishing, marketing and design.

Daniel

Daniel

Mac Genius

4,711 satisfied customers

Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.

Vinod Menon

Vinod Menon

Support Specialist

2,370 satisfied customers

worked as a Tech support Associate for Apple products

John T. F.

John T. F.

Mac Druid

1,979 satisfied customers

20+ years in the computer/Mac industry

David

David

Mac Support Specialist

1,468 satisfied customers

BSc H.Dip Apple Certified Professional

Claws224

Claws224

IEEE Datacommunication Engineer

965 satisfied customers

IEEE, Microsoft

Mac Tech

Mac Tech

Apple Specialist

888 satisfied customers

7 + Years Supporting Apple Products

< Previous | Next >

Related Mac Questions
I cannot open Excel on my iMac. Os El Capitan X 10.11-6.
I WAS AWAY ALL LAST WEEK. TURNED OFF MY COMPUTER AND WHEN I RETURNED EXCEL NO LONGER RESPONDED… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,212 satisfied customers
Im on my moms computer trying to help her. Her excel program
Im on my moms computer trying to help her. Her excel program is not working and will not open at all. I have the original Office.mac dvd but dont know how to reinstall excel without losing whatever da… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
My microsoft excel froze with the SWOD. Mac os sierra. A
my microsoft excel froze with the SWOD JA: What's the model and Operating System (OS) of your device? Customer: mac os sierra JA: When did you purchase your Apple device? What troubleshooting have you… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I can't open excel on my Mac. This is a MacBook Pro Retina
This is a MacBook Pro Retina 2012 and operating macOS Sierra … read more
Jason Jones
Jason Jones
AAS Information Technology
6,316 satisfied customers
I can't dictate into excel with dragon Pre 15. Dell. Few
I can't dictate into excel with dragon Pre 15 JA: What's the make and model of your computer? And what version of Excel are you using? Customer: dell JA: Have you installed any updates recently? Custo… read more
Justin Johnson
Justin Johnson
Training and Development Contractor
502 satisfied customers
I have been using Excel for years now. In the last few
I have been using Excel for years now. In the last few weeks, whenever I input information and hit the "enter" key, the line I entered information on turns black. The info is there but not visible unl… read more
Kris R
Kris R
IT Manager
Computing
2,305 satisfied customers
Hanging with Word and Excel - just did updates. No idea. It
It is a Mac mini, i7 with 16 mb ram purchased in 2013, it should be running the latest Mac OS … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I tried to download Adobe Export PDf to save in excel
I tried to download Adobe Export PDf to save in excel format. I signed up for the 1.99/mo though it didn't let me download and as I try to do it again it says I have already done it and can't do it ag… read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
426 satisfied customers
When using excel it keeps reexing and I get the littl
when using excel it keeps reexing and I get the littl spinnng wheel what can i do to combat this … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,212 satisfied customers
Excel for Mac. The tabs at the bottom of the page have
Excel for Mac. The tabs at the bottom of the page have disappeared. Tried changing preferences as suggested and no change.Thanks.… read more
Jon
Jon
Bachelors Degree
390 satisfied customers
I need the excel text converter for mail merge on an old
I need the excel text converter for mail merge on an old macbook pro … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
775 satisfied customers
I am getting this error in my Mac word and excel Microsoft
I am getting this error in my Mac word and excel Microsoft Error Reporting log version: 2.0Error Signature: Exception: EXC_BAD_ACCESS Date/Time: 2017-08-23 02:58:26 +0000 Application Name: Microsoft W… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I cannot see tabs in an excel document, its on cloud, 1 full
i cannot see tabs in an excel document JA: When did you last update Excel? Customer: its on cloud JA: What have you tried so far with your Excel? Customer: 1 full screen 2. tiled in window view JA: An… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
628 satisfied customers
I have the 2004 version of Excel & Word for MAC. If I
I have the 2004 version of Excel & Word for MAC. If I upgrade to 2016, will my spreadsheets work seamlessly? Thank you. … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
My excel is freaking out and opening many random files,
my excel is freaking out and opening many random files … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have a Mac desktop with microsoft word and excel
I have a Mac desktop with microsoft word and excel applications. The document I wish to open in excel keeps giving me a not responding message. … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Send Mac Basics: Address Book. Using OS Sierra 10.12.4. I
please send Mac Basics: Address Book. Using OS Sierra 10.12.4 … read more
Mike
Mike
Mac Medic
Some college
8,552 satisfied customers
My address book will not open - showing 1712 what should I
Hello, my address book will not open - showing 1712 what should I do? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x