Microsoft Office 2007/2010 on a PC computer - University Relations and ...
Nametag Mail Merge
Microsoft Office 2007/2010 on a PC computer
1
Start with your excel document. When creating your excel document think about all the different ways you want to use the information. When creating nametags, you will want a person's first
name, last name, and possibly their title or department. It is best to make separate columns in
your spreadsheet for each part of a person's name. This allows you the freedom to either merge
the information together onto one line or to put the first name and last name on separate lines.
A sample of what your excel spreadsheet might look like when you are ready to mail merge the
information is:
First Name Sally John
Last Name Smith Thomas
Work Title Office Assistant Director
Department College of Business College of Business
2 Once you have your matrix completely filled in, everything spelled correctly and all capital letters
used appropriately you are ready to make nametags. Note: The information will be inserted exactly as it is typed in the excel matrix. Be sure all information is correct!
3 Open a blank Word document and begin the mail merge process. The mail merge function can be
found under the Mailing tab. Click on the down arrow next to the "Start Mail Merge" icon. At the bottom of this list, you will see "Step by Step Mail Merge Wizard". This wizard will help walk you through the mail merge process.
Note: While the Mail Merge Wizard is fairly intuitive, the following screen shots help you navigate along the process and shows you what you should be seeing at each step of the way.
4 You need to select your document type. Labels are used as the template for nametags.
5
You will need to choose the type of labels you will be using. Microsoft Word recognizes a variety of commercial labels, with these already programmed into the system.
3
6 Browse and select the excel file you will be using for your mail merge.
7
You will be asked to select the recipients you want included from the excel file in your mail merge. Make sure that there is a check mark by the names of recipients you would like to include in this merge. If
there are people from your list that do not need to be part of this merge, be sure to unmark their name.
8
The label in the top left is your primary label, which is where all initial additions to your nametags will take place. "More items" allows you to add fields from the linked excel file to this document to begin
designing your nametags. The label in the top left is your primary label. This is the place that will be
updated with any fields that you insert.
9 Once the primary label is fully formatted, make sure to update all labels.
10 Once you are done formatting your labels and are happy with the way they look, complete the merge.
11
After the merge is complete, you will want to "Edit individual labels". This function allows you to make edits to the labels that need special formatting. For example, a first name does not fit on one line due to
the size of the font. You will want to resize this element on that specific label to fit on one line.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- an introduction to combining pdf and microsoft office documents evermap
- sw31 ms word mail merge to pdf university of aberdeen
- microsoft office 2016 mail merge akron summit county public library
- microsoft pdf files
- mail merge microsoft office 2010 delta state university
- microsoft word how to embed pdf com
- merge word documents online to pdf
- 7 mail merge and related operations form letters and mailing labels
- intermediate microsoft word mail merge envelopes labels
- microsoft office 2007 2010 on a pc computer university relations and
Related searches
- update microsoft office 2007 to 2010 free
- microsoft office 2007 free download windows 10
- microsoft office 2007 download windows 10
- microsoft office 2007 free download w10
- microsoft office 2007 download for windows 10
- free microsoft office 2007 setup
- microsoft office 2007 free download pc
- microsoft office 2007 updates for windows 10
- download microsoft office 2007 free windows 7
- microsoft office 2007 full free download
- microsoft office 2007 64 bit
- microsoft office 2007 software download