How to generate mailing labels from Excel using Office 365 Home version. Cannot export Excel data to Word 30 label template.

Question

I've been trying too long and I know it can't be too difficult and I'm old and tired of trying. HELP please!

Answer 1

Hi John,

This is not a matter of "exporting" but rather bringing the data into Word as a mail merge.

Mail merge using an Excel spreadsheet 

https://support.office.com/en-us/article/mail-m...

Microsoft MailMerge Resource Center 

  Data Sources

  Data Sources You Can Use for a Mail Merge

  Prepare Your Excel Data Source for a Mail Merge

  Mail Merge Using an Excel Spreadsheet

  Sort and Filter Data for a Mail Merge

  Document Types

  Labels

This forum is a user-to-user support forum. I am a fellow user. I'm considered old by some, as well.

I hope this information helps.

Please let me know if you have any more questions or require further help.

You can ask for more help by replying to this post (Reply button below).

Regards

Answer 2

I agree with Charles, a mail merge is what you want to do

Beginning a Mail Merge 

http://wordribbon.tips.net/T005965_Beginning_a_Mail_Merge.html

Performing a mail merge can be intimidating to some people. It needn’t be; Word provides step-by-step wizards that lead you through the process. How you use these wizards is dependent on the version of Word you are using, however.

.

**Creating a Mail Merge Data File**

http://word.tips.net/T001369_Creating_a_Mail_Merge_Data_File.html

An easy way to perform a mail merge starts with creating a data file in a Word document. This tip shows how you can create the data in a document in a tabular format that can be easily understood by the mail merge feature.

.

**Creating a Mail Merge Data Source**

http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

Microsoft Word supports many file formats which can be used as a Data Source for a mail merge. This article covers specifications and frequently asked questions on the most commonly used Data Sources, along with how to set up a Data Source in Word.

.

Design and set up a mail merge address list in Word

https://support.microsoft.com/en-us/help/294688/how-to-design-and-set-up-a-mail-merge-address-list-in-word

This article describes the acceptable formats for a mail-merge address list and includes suggestions and questions that are helpful to ask yourself as you create an address list.

.

This is the first article in a good series, but parts of it are not available on the web so you have to know where to look

Essentials of Creating a Mail Merge with Word 2007 (in 9 parts)   Series: By Dan Gookin

http://www.dummies.com/how-to/content/the-essentials-of-creating-a-mail-merge-with-word-.html

Merging your mailing lists with documents you want to send via e-mail is easier with essential steps clearly described. The mail merge tool in Word 2007 can streamline the process of getting the word out to many recipients — without manually personalizing a multitude of e-mails

.

Step 1: Creating the Main Document 

https://web.archive.org/web/20151024144338/http://www.dummies.com/how-to/content/word-2007-mail-merge-step-1-creating-the-main-docu.seriesId-231323.html

.

Step 2: Assigning Fieldshttps://web.archive.org/web/20160405111748/http://www.dummies.com:80/how-to/content/word-2007-mail-merge-step-2-assigning-fields.seriesId-231323.html

.

Building Recordshttps://web.archive.org/web/20160105014626/http://www.dummies.com:80/how-to/content/word-2007-mail-merge-step-5-the-final-merge.seriesId-231323.html

.

Inserting Fields Into The Main Documenthttp://www.dummies.com/how-to/content/word-2007-mail-merge-step-4-inserting-fields-into-.seriesId-231323.html

.

The Final Mergehttps://web.archive.org/web/20160105014626/http://www.dummies.com:80/how-to/content/word-2007-mail-merge-step-5-the-final-merge.seriesId-231323.html

.

How To Create Labels With Mail Merge In Word 2007https://web.archive.org/web/20160707154630/http://www.dummies.com:80/how-to/content/how-to-create-labels-with-mail-merge-in-word-2007.seriesId-231323.html

.

How To Add Graphics To Labels In Word 2007https://web.archive.org/web/20160614153843/http://www.dummies.com:80/how-to/content/how-to-add-graphics-to-labels-in-word-2007.seriesId-231323.html

.

Part 9 How To Print Envelopes In Word 2007https://web.archive.org/web/20160707151042/http://www.dummies.com/how-to/content/how-to-print-envelopes-in-word-2007.seriesId-231323.html 

.

Finally, there is this article about being careful when using test data.

Checking a Word mail merge for bad names or test strings 2018 04 18****https://office-watch.com/2018/check-word-mail-merge-bad-names-test-strings/

In the UK there’s been a lot of laughs and some red faces about a money raising letter ‘signed’ by the Conservative Prime Minister to a ” Mr Youmustbe F*ckingjoking ” and sent to a pensioner. It’s easy to laugh but anyone who has done large mailings knows that it’s a case of “There but for the grace of God …”. It’s the sort of thing that any professional mail manager should check for.  We’ll show you a simple way to check in Word for mail and email merges.

WT MR Mail Merge Magic - Envelopes.doc

Answer 3

Thanks, it's a lot to absorb and that's for tomorrow.

Answer 4

Thanks, it's a lot to absorb and that's for tomorrow.

Answer 5

Start with the first link. It may be all you need and is fairly short.