Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac
This answer was rated:

I have created a list of addresses in an Excel file. I am

I have created a list...
I have created a list of addresses in an Excel file. I am using an OS X Mac. I go to Manage Mail Merge in Word. I tell it to Create new labels. In that same window appears 2. Get recipient list. When I click on it, I get nothing. I can't seem to get that list into the Word mail merge. Everything else works.
Show More
Show Less
Ask Your Own Mac Question
Answered in 6 minutes by:
12/16/2012
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
Hi,

First you need to make sure that the addresses are correctly listed in the excel file. Any gap or empty header could cause a problem in mail merge. Would you be able to send me the file so I can check it for you
Ask Your Own Mac Question
Customer reply replied 5 years ago

How do I send the file?

You can go to http://www.wikisend.com/ and upload the file using the Browse button (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 did this 3 times looking for a browse button. Did you mean the upload button? The first time I get ID# XXXXX

Customer reply replied 5 years ago

What's happening?

Checked the file and it looks fine

I used that file to create a list of labels using mail merge and here is a sample of the result

graphic



I can send you the file with the labels if you can tell the type or size of labels you would like to use
Ask Your Own Mac Question
Customer reply replied 5 years ago

I want to know how I can do this myself.

Preparing the instructions takes much longer than doing the work. Let me send you the file with the finished result. If it works for you I will then prepare the instructions after rating the answer. Ok?

Ask Your Own Mac Question
Customer reply replied 5 years ago

OK. I'm using Avery 18160. actual size 1" x 2 5/8".

Ok here is the doc file with all the labels

 

Attachment: 2012-12-16_202345_m.docx

 

Thanks. In the meantime I will prepare the instructions...

 

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

Ok? Any problems?

 

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

How did you get the Excel file into Word?

I'm preparing the instructions. As agreed please go ahead and rate the answer. You can add bonus later after finishing the instructions

 

Thanks

 

 

 

Ask Your Own Mac Question

Thanks.

 

Here are the step by step instructions

 

Attachment: 2012-12-16_234831_mail_merge_instructions.docx

 

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

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

I just realized that the first three names and addresses of my Excel file you were working on yesterday did not print. Do I need to send the file to you again?


Also, your final directions to me--I can't find any mailing tab on any of my bars when I am in Excel. There is a "Mail" on the tools list, but it is not bright. It won't do anything for me, so I'm no better off than before. I have Excel 2008. Can you tell me what to do? Can you redo that mailing label lsit?

No problem I will do it again and also will fix the printing of the first three names

 

Please send me the new file

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

Didn't you get the file? I'm been out of the house and just returned.

No, I'm waiting for you to send me the file ID # so I can download it

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

I just replied to your latest e-mail and attached the file. I thought I did that this afternoon. Should I do something else?

No you need to send it the same way you sent it yesterday. Here are the instructions again

 

Go to http://www.wikisend.com/ and upload the file using the Browse button (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.

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

It's not giving me a File ID. It just asks for a file name. Then it says it can't find it. I think that number is in my files now, socan Iattach it and send it?

Ok try uploading it at this site, then send me the download link that you will get

 

http://www.ge.tt/#!/

 

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

How do I send it? The file title shows up but I can't move it.

COPY the link that they give you and PASTE it here

 

.

You are able to send me the first file, so happened? why can't you send it the same way as you did before

 

 

 

 

 

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

I see no link. How do I COPY? How do I paste? The first time I went to wikisend they gave me an ID #. Now they don't. At the other link I uploaded the file from my Excel list. It now shows in a box. In fact, I did it twice, so there's two boxes with the file name. Above them is a box that says UPLOAD. I click on that, and it just takes me back to the file list . I don't think I need a third box. At the very top, there's a box that says drag and drop. I can't get anything to move. My only problem is that the first three lines of my file have no labels printed.

After it finishes uploading the file, copy the web address from the top of the browser, as shown below, then paste it in your reply to me

 

 

 

 

 

\

 

 

 

 

 

Or you can attach it by email to the site moderator at [email protected],com , putting "John D" in the Subject line, and asking them to forward it to me. It might take a few hours until they can forward it to me

 

 

 

 

 

 

Ask Your Own Mac Question
Customer reply replied 5 years ago

Ge.tt Gett sharing


 


If this isn't right, I'll try the e-mail.

No that's the web address BEFORE it finishes uploading the file.

Yes I think it's better to send it by email. Will take some time until they forward it but I will eventually get it

Ask Your Own Mac Question
Ok I got the excel file this morning and I created the labels and printed them to make sure that. all labels get printed including the first set, which they indeed did.

Here is the label file

Attachment: 2012-12-18_145427_m1.docx



Hope this helps
Ask Your Own Mac Question
Customer reply replied 5 years ago

Sorry. Everything works until the file appears. There are no names, etc. Just labels with titles in place,

hmm.. I'm not sure what is happening in your system. Everything is working as it should on my end.

 

Anyway I created a stand alone document with the addresses which should make it easier for you to use independent of the excel file and print your labels from it

 

Attachment: 2012-12-18_163905_m3.docx

 

 

I also converted the file to a pdf file in case you want to use this file to directly print from

 

Attachment: 2012-12-18_164020_m3.pdf

 

 

Also here is the print preview image showing that all the labels with the names etc print ok from the Word file

 

 

 

Hope this helps

 

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,555 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,394 satisfied customers

worked as a Tech support Associate for Apple products

John T. F.

John T. F.

Mac Druid

1,994 satisfied customers

20+ years in the computer/Mac industry

David

David

Mac Support Specialist

1,507 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 have Microsoft office for apple (Mac). I deleted excel and
I have Microsoft office for apple (Mac). I deleted excel and power point, how do I get em back? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have an Excel workbook that opens extremely slow. What can
I have an Excel workbook that opens extremely slow. What can I do to speed it up? Thank you. … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
I have a Mac with Microsoft ( word, powerpoint Excell and
I have a Mac with Microsoft ( word, powerpoint Excell and Outlook)I need to upgrade to outlook 2016. I am having problems as I don't remember my microsoft log in password Help … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I just purchased the excel-etal. I can't get excel to open.
I just purchased the excel-etal. I can't get excel to open … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
I had to update my Word and Excel recently and I have had
I had to update my Word and Excel recently and I have had nothing but problems every since. I can't Save As two different Excel docs. I try to close them and I get a whirling wheel and "Refreshing" wh… read more
Josh
Josh
It Support Specialist
Associate Degree
5,138 satisfied customers
Microsoft office outlook and excel and word will not open, i
microsoft office outlook and excel and word will not open, i get the message this application will not open correctly with a code Oxc0000142. what must I do to correct ? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
I sent my wife and Excell file but we only have access to
I sent my wife and Excell file but we only have access to Mac computer so need to know how to convert it into pages to be able to open it on a MacBook pro … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,275 satisfied customers
I have been using the microsoft one cloud/ excel and word
I have been using the microsoft one cloud/ excel and word apps on my apple Ipad. it is telling me (after two years use) that it can not connect with the internet. Meanwhile all my other apps can? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
Can I back out an upgrade to Excel without losing files? OS
Can I back out an upgrade to Excel without losing files? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I am trying to understand why the Mail merge from Excel to
I am trying to understand why the Mail merge from Excel to Word will not work on my brand new computer??? The excel is saved in the format ".xlsx" but it still says I need an Excel Workbook Text Cover… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
I just this afternoon updated microsoft office excel but I
I just this afternoon updated microsoft office excel but I don't want it now. I have a backup external hard drive. can i get rid of the update by downloading from time machine. if so, how? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
I am trying to save updates to an excel spreadsheet on my
I am trying to save updates to an excel spreadsheet on my new 27" Mac that I brought in from a 10 year old Mac. I get a "something went wrong" massage, which recommended that I contact you. … read more
Cabletech
Cabletech
High School or GED
140 satisfied customers
I've used Excel for years with no problems. I have a new
I've used Excel for years with no problems. I have a new iMac desktop with a more current OS and Excel version than I have been using. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
I guess I need to update my Excel but not sure how to do it.
I guess I need to update my Excel but not sure how to do it … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
Excel for Mac opens to a blank Excel file, When I bought the
When Excel opens to a blank file, it also freezes my machine from doing other things, such as logging out, restarting, etc. I've done a forced shutdown (holding down the power button), but this hasn't helped. Same problem exists once I restart the machine. … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
780 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
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
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
479 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