# What am I doing wrong, Mail Merge-wise?

**URL:** <https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057>\
**Category:** Factual Questions\
**Created:** [October 16, 2009, 5:22pm UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057 "2009-10-16T17:22:50Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![handsomeharry](https://avatars.discourse-cdn.com/v4/letter/h/e9c0ed/32.png) [@handsomeharry](https://boards.straightdope.com/u/handsomeharry)\
**Post date:** [October 16, 2009, 5:22pm UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057/1 "2009-10-16T17:22:50Z")

</div>

Well, I got my Mail Merge up and going; however, it is only displaying the first page of labels, some thirty, while my source file has 300. This doesn’t work for my plan.  
My source is xl, or whatever the extension for the 2007 XL office junk is.  
So, what did I forget? I didn’t do anything weird that I’m aware of, and my Recipients list has all 300. Can you help?  
Thanks,  
hh

---

<div class="post-metadata">

**Author:** ![tdn](https://avatars.discourse-cdn.com/v4/letter/t/94ad74/32.png) [@tdn](https://boards.straightdope.com/u/tdn)\
**Post date:** [October 16, 2009, 5:27pm UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057/2 "2009-10-16T17:27:28Z")

</div>

How many pages is your merged document?

---

<div class="post-metadata">

**Author:** ![Anaamika](https://avatars.discourse-cdn.com/v4/letter/a/5f9b8f/32.png) [@Anaamika](https://boards.straightdope.com/u/Anaamika)\
**Post date:** [October 16, 2009, 7:19pm UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057/3 "2009-10-16T19:19:40Z")

</div>

Did you click “finish and merge” in the upper right hand corner? Usually it shows you the first 30 as a sample of how it will look, then you have to finish and merge and then it shows you all of it.

---

<div class="post-metadata">

**Author:** ![handsomeharry](https://avatars.discourse-cdn.com/v4/letter/h/e9c0ed/32.png) [@handsomeharry](https://boards.straightdope.com/u/handsomeharry)\
**Post date:** [October 19, 2009, 2:39am UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057/4 "2009-10-19T02:39:12Z")

</div>

**tdn,** I think about 10 pages.  
**Anaamika,** I did that, and I can’t quite find the other 9 pages.

Thanks,  
hh

---

<div class="post-metadata">

**Author:** ![Shot\_From\_Guns](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@Shot\_From\_Guns](https://boards.straightdope.com/u/Shot_From_Guns)\
**Post date:** [October 20, 2009, 4:44pm UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057/5 "2009-10-20T16:44:56Z")

</div>

Did you try a test print, on regular paper? IIRC, the document doesn’t always display the entire merge.

---

<div class="post-metadata">

**Author:** ![Shot\_From\_Guns](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@Shot\_From\_Guns](https://boards.straightdope.com/u/Shot_From_Guns)\
**Post date:** [October 20, 2009, 4:53pm UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057/6 "2009-10-20T16:53:47Z")

</div>

Yup, I just did a test merge in Word, and it only displays the first page of labels. If you want to see everything, you have to click \*\*Edit Individual Labels… \*\*This will pop up a little dialogue titled **Merge to New Document**. Select \*\*All \*\*and hit **Okay**. Voila, a new document with your entire merge.

---

<div class="post-metadata">

**Author:** ![handsomeharry](https://avatars.discourse-cdn.com/v4/letter/h/e9c0ed/32.png) [@handsomeharry](https://boards.straightdope.com/u/handsomeharry)\
**Post date:** [October 20, 2009, 7:52pm UTC](https://boards.straightdope.com/t/what-am-i-doing-wrong-mail-merge-wise/514057/7 "2009-10-20T19:52:39Z")

</div>

Perfect! Thanks, everybody, for your help!

hh