Microsoft Word Mac Postcard Template Auto Populate

07.04.2020
3 Comments

Today’s author, Eric Patterson, a Program Manager on the Excel team, describes how to use Excel Tables as a source for a mail merge – a great productivity tool for sending out holiday greeting cards! 🙂 Eric wrote this before the holidays but unfortunately I was out of the office and didn’t get to post this until now. Very useful nonetheless.

Create great-looking postcards in minutes with premium postcard templates for Microsoft Word & Publisher. Get professionally-designed layouts that include pictures & graphics. Get the quality you expect from Avery, the world’s largest supplier of labels. Download a Postcard Template and Start Working on It. Microsoft Office Word has default templates that you can use. However, you can use a more personalized template. Look for a reliable template on the internet. Choose a sample postcard template that works best with your postcard. The advantage of using a template is it will give you a head.

At this time of the year I find myself preparing to send out a large number of greeting cards to friends and family. I have most of my addresses in Excel with columns for FirstName, LastName, Address, City, State and Postal Code. The workbooks looks like this:

Microsoft

If you’re like me, you don’t keep your address list up to date and you don’t print envelopes often. I have a number of addresses that I know are correct but there are others that I need to confirm before printing them out. Given the number that I need to do for the holidays, I do want to get started though.

Creating a Table

The first step is to create a Table from the list of addresses.

  • Select a cell within the range containing the addresses, such as cell B2.
  • On the Insert Tab, click on the Table button
  • A dialog will appear asking for the range of cells containing your addresses and whether your table has headers. Verify that the items are correct and click OK.
  • The range of cells will now have a table style applied and dropdowns at the top of each column that provide options for sorting and filtering.

Defining a Name for the Table

Excel allows you to define names that apply to a range of cells in the worksheet. When a name is defined for a Table in a worksheet, the name will update automatically as the table is resized to add or remove data. This is helpful in this case because I want to add and remove addresses during the process of printing envelopes.

  • To define a name, click “Define Name” command on the Formula Tab.
  • In the New Name dialog, type the name Addresses and the range of cells your addresses are in ($B$2:$G$15 in this case)
  • Click on OK to create the name

Verifying Addresses

After my Table is created and a name applied, I start going through the addresses to confirm which ones are correct. I do this by adding a new column to the Table for this year. To do this, just type 2008 in cell H2. The Table and the name that we defined will expand automatically. Once you have the new column, then you can type something in the column to indicate whether the address is correct. I used a “Y” in my list.

Sorting the List

Next I want to separate the table into 2 tables; one for confirmed addresses and one for those that need to be updated.

  • Click on the dropdown in the 2008 column
  • Click on the Sort A to Z command and click OK
Microsoft Word Mac Postcard Template Auto Populate

Here is what the sorted table looks like:

Separating the Tables

The next step is to cut and paste the unconfirmed addresses to another sheet in the workbook

On a Mac keyboard, the Command key is denoted with the symbol. For information about changing the key assignment of a keyboard shortcut, see Mac Help for your version of the Macintosh operating system (OS) or see your utility application. Also see Keyboard Shortcuts in OneNote for Mac later in this topic. If you don't find a keyboard shortcut here that meets your needs, you can create a custom keyboard shortcut. For instructions, go to Create a custom keyboard shortcut for Office for Mac. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel for Mac. However, not all do. Vscode mac replace shortcut. If you don't find a keyboard shortcut here that meets your needs, you can create a custom keyboard shortcut. For instructions, go to Create a custom keyboard shortcut for Office for Mac. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Word for Mac. However, not all do. Dictate download. 2019-3-20  Testing in Microsoft Word for Office 365 MSO (16.0.4) 64 Bit. Dictate 64 because I believe it would work much better for the blind if only I could somehow active/deacivate the 'Dictate' button with a keyboard shortcut. The ALT-Q 'tell me what to do' doesn't show the 'Dictate' icon when you type dictate.

  • Select the table headers and copy and paste to a new worksheet (I named the sheet “NeedAddresses”)
  • Select the records that are unconfirmed and cut and paste them to the new worksheet below the headers
  • The Table will need to be resized to exclude the blank rows. Using the arrow handle in the lower right corner of the table, resize it to just include your addresses.
  • Save your workbook (Addresses.xlsx) and you are now ready for the mail merge.

Start the Mail Merge

The steps above created a workbook containing a table of addresses on one sheet that has a name (Addresses) defined that corresponds to the table range. The remaining steps will show how to create the mail merge in Word to create envelopes.

  • Start Microsoft Word
  • On the Mailings tab, select the Start Mail Merge / Envelopes Command
  • Select the appropriate Envelope size and click OK
  • Select the Use Existing List command from the Select Recipients Dropdown
  • Select your address file in the Select Data Source dialog and click Open
  • Select the Defined Name, “Addresses” in the Select Table dialog and click OK

Free Postcard Template

The Word document is now connected to the Table in Excel.

Adding the Address Block and Previewing Envelopes

Next you can insert the address block into your envelope and preview the results

  • On the Mailings tab click on the Address Block command to add an address block
  • Position the address block where you want it on the envelope by adding carriage returns, center alignment, etc.
  • To Preview what it will look like, click on the “Preview Results” command.
  • You can also use the other commands in the Preview Results group to find recipients or navigate through the addresses.
  • When everything looks good, you can click on the Finish & Merge dropdown to print your envelopes.
  • In the Merge to Printer dialog, I would suggest starting with just the current record to make sure that you have the envelope positioned correctly.

    Tip: Cut plain paper the size of the envelope and add marking to show the positioning, then use it for a few trial runs.

  • When things are printing as expected, you may want to print sets of say 10 envelopes at a time based on your printer using the From __ To: __ choice in the merge to printer dialog.

How do I finish my Envelopes?

As you validate more of your addresses, or if you want to send a card to someone that wasn’t on your original list, follow these steps:

  • First you need to clear the addresses that you’ve already printed. I copy the entire table to a sheet named “Printed” to start with, then clear the contents of the cells within the original table, leaving the table headers.
  • Next I copy addresses from my “NeedAddresses” sheet and paste them just below the headers in the “ReadyToPrint” sheet which will expand the Table and the Addresses defined name.

More information about creating mailing labels with Excel and Word.

Today we welcome back Seth Fox, Word team Program Manager, to explain how you can easily start new documents that come with built-in personality.

Last month I introduced the Start screen in the Word 2013 and discussed how templates and built-in content can be used to quickly create great looking documents. Today I’m excited to introduce new starting documents that are featured on the Start screen.

We know that over half of all Word sessions start from a blank document. These documents can end up looking very different, but in previous versions of Word they all started with the same settings.
In the Word 2013, we have made it easier for you to create great looking documents, allowing you to focus on content instead of formatting. For example, if you know you’re writing a paper for class and your professor has instructed that the paper must be singled spaced, you can now get started with a single click of the “Single spaced (blank)” template. There are also specialized templates that let you create documents with very different personalities without any formatting tweaks on your part. For example, if you need a clean, modern document that has numbered headings, simply click on the “Report design (blank)” template.

As you apply heading styles to text, they will automatically be formatted with a number. Formatting the rest of your document is as easy as selecting your desired style in the Style gallery from the Home tab – see Caitlin’s post on changing your style in Word 2013 to learn more about the power of styles. Or if you want a clean looking document that’s different from the same-old default look, all it takes is a click on “Ion design (blank)” and you’re on your way.

4x6 Postcard Template Microsoft Word

Design templates open with text already formatted with frequently used styles. Simply replace the text with your own words to get started.

4 Postcard Templates For Word

You can search for additional blank templates by clicking on the suggested search or searching for the term “blank”. If you find one you love, you can pin it to the Start screen to make sure it’s always at your fingertips.

Free Postcard Template Downloads

Thanks for reading! I hope you find it easier than ever to get started in Word 2013, whether it’s creating a new document, opening a recent one, or using a template.