Postcard mail merge troubleshooting?

Hi,
I read another post that addressed this same question but I didn't find the
solution to be helpful in my situation.

I created a postcard using a template from Publisher 2007 and modified it.
I selected the Avery 8387 page size as I am using the Avery postcards.

I then created the postcard (front and back) and then did a mail merge using
an excel sheet. Everything looked great and all the names were showing up.
When I go to print, the same name shows up on all 4 postcards.

My printing selections are "Multiple Copies Per Sheet" and I end up getting
4 of the front which is ok but the back side of the postcard shows all 4 with
the same person.

I am totally frustrated because I am also struggling with my Canon Printer
putting the back side up side down.

So maybe I should ask if there is a way to print all of the back side of the
postcards with the mail merge seperate. Then manually flip them over and
print them in the right direction and print off the front sides?

Thanks so much! I offered to do this for someone and it needs to go out
soon.

Shawn

Create two publications. Printing both sides of a mail merge is problematic.

Somewhere in your printer setup will be an option to "flip pages up" or similar
dialog, you will want to disable this if you are duplexing.




--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"budnspuds" wrote in message
...
Hi,
I read another post that addressed this same question but I didn't find the
solution to be helpful in my situation.

I created a postcard using a template from Publisher 2007 and modified it.
I selected the Avery 8387 page size as I am using the Avery postcards.

I then created the postcard (front and back) and then did a mail merge using
an excel sheet. Everything looked great and all the names were showing up.
When I go to print, the same name shows up on all 4 postcards.

My printing selections are "Multiple Copies Per Sheet" and I end up getting
4 of the front which is ok but the back side of the postcard shows all 4 with
the same person.

I am totally frustrated because I am also struggling with my Canon Printer
putting the back side up side down.

So maybe I should ask if there is a way to print all of the back side of the
postcards with the mail merge seperate. Then manually flip them over and
print them in the right direction and print off the front sides?

Thanks so much! I offered to do this for someone and it needs to go out
soon.

Shawn

Thanks Mary!!!

I will do that. It sounds like it will be much easier. I appreciate
your help!

"Mary Sauer" wrote:

Create two publications. Printing both sides of a mail merge is problematic.

Somewhere in your printer setup will be an option to "flip pages up" or similar
dialog, you will want to disable this if you are duplexing.




--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"budnspuds" wrote in message
...
Hi,
I read another post that addressed this same question but I didn't find the
solution to be helpful in my situation.

I created a postcard using a template from Publisher 2007 and modified it.
I selected the Avery 8387 page size as I am using the Avery postcards.

I then created the postcard (front and back) and then did a mail merge using
an excel sheet. Everything looked great and all the names were showing up.
When I go to print, the same name shows up on all 4 postcards.

My printing selections are "Multiple Copies Per Sheet" and I end up getting
4 of the front which is ok but the back side of the postcard shows all 4 with
the same person.

I am totally frustrated because I am also struggling with my Canon Printer
putting the back side up side down.

So maybe I should ask if there is a way to print all of the back side of the
postcards with the mail merge seperate. Then manually flip them over and
print them in the right direction and print off the front sides?

Thanks so much! I offered to do this for someone and it needs to go out
soon.

Shawn

I couldn't get templates to print correctly either, but I finally figured it
out.

Design your postcard. Do your merge. Your postcard should be two pages. One
page with the design and the other page the mailing information. The key is
in the print set-up, not the merge.

Select: "Print Merge."
Select: "print multiple pages per sheet"
Paper Size: "letter"
Orientation: "Landscape"
2-Sided Printing Options: "two-sided, flip short side"

The result is an 8 1/2 x 11 paper with two post card designs along the left
and two DIFFERENT addresses (a,b) along the right on paper side. If you flip
the paper over, like turning a page in a book, you have postcard designs
along the left again and two more different address (b,c) along the right.
When you cut them, you get 4 postcards with the same design on one side and 4
different address (a, b, c, d) on the other.

Finally success!

Shelley


"budnspuds" wrote:

Thanks Mary!!!

I will do that. It sounds like it will be much easier. I appreciate
your help!

"Mary Sauer" wrote:

Create two publications. Printing both sides of a mail merge is problematic.

Somewhere in your printer setup will be an option to "flip pages up" or similar
dialog, you will want to disable this if you are duplexing.




--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"budnspuds" wrote in message
...
Hi,
I read another post that addressed this same question but I didn't find the
solution to be helpful in my situation.

I created a postcard using a template from Publisher 2007 and modified it.
I selected the Avery 8387 page size as I am using the Avery postcards.

I then created the postcard (front and back) and then did a mail merge using
an excel sheet. Everything looked great and all the names were showing up.
When I go to print, the same name shows up on all 4 postcards.

My printing selections are "Multiple Copies Per Sheet" and I end up getting
4 of the front which is ok but the back side of the postcard shows all 4 with
the same person.

I am totally frustrated because I am also struggling with my Canon Printer
putting the back side up side down.

So maybe I should ask if there is a way to print all of the back side of the
postcards with the mail merge seperate. Then manually flip them over and
print them in the right direction and print off the front sides?

Thanks so much! I offered to do this for someone and it needs to go out
soon.

Shawn

OK, I've tried this and everything else I can think of. What I'm getting,
most recently after trying Shelley's fix, is one copy of the postcard with
its corresponding reverse side. It is reduced in size so that the postcard
front covers 1/16 of the page in the top left corner, and the postcard back
is next to it, so all together is takes up 1/8 of the top left of the page.

The print preview shows full sizes on the page, but the print comes out
reduced.

I am printing to a Xerox Workcenter 7132.

In Publisher 2003 I had no problems printing the two sided mail merge
document.

Thanks for any help you can give.

"Shelley" wrote:

I couldn't get templates to print correctly either, but I finally figured it
out.

Design your postcard. Do your merge. Your postcard should be two pages. One
page with the design and the other page the mailing information. The key is
in the print set-up, not the merge.

Select: "Print Merge."
Select: "print multiple pages per sheet"
Paper Size: "letter"
Orientation: "Landscape"
2-Sided Printing Options: "two-sided, flip short side"

The result is an 8 1/2 x 11 paper with two post card designs along the left
and two DIFFERENT addresses (a,b) along the right on paper side. If you flip
the paper over, like turning a page in a book, you have postcard designs
along the left again and two more different address (b,c) along the right.
When you cut them, you get 4 postcards with the same design on one side and 4
different address (a, b, c, d) on the other.

Finally success!

Shelley


"budnspuds" wrote:

Thanks Mary!!!

I will do that. It sounds like it will be much easier. I appreciate
your help!

"Mary Sauer" wrote:

Create two publications. Printing both sides of a mail merge is problematic.

Somewhere in your printer setup will be an option to "flip pages up" or similar
dialog, you will want to disable this if you are duplexing.




--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"budnspuds" wrote in message
...
Hi,
I read another post that addressed this same question but I didn't find the
solution to be helpful in my situation.

I created a postcard using a template from Publisher 2007 and modified it.
I selected the Avery 8387 page size as I am using the Avery postcards.

I then created the postcard (front and back) and then did a mail merge using
an excel sheet. Everything looked great and all the names were showing up.
When I go to print, the same name shows up on all 4 postcards.

My printing selections are "Multiple Copies Per Sheet" and I end up getting
4 of the front which is ok but the back side of the postcard shows all 4 with
the same person.

I am totally frustrated because I am also struggling with my Canon Printer
putting the back side up side down.

So maybe I should ask if there is a way to print all of the back side of the
postcards with the mail merge seperate. Then manually flip them over and
print them in the right direction and print off the front sides?

Thanks so much! I offered to do this for someone and it needs to go out
soon.

Shawn

The only fault I find with Shelley's fix is the *two-sided, flip short side up*.
I use two sided without the flip. I also use the Avery US Letter postcard
setup.(8383). For some reason the postcard templates work better than the
default.

But the rest is spot on using File, Print Merge and Multiple pages per sheet.
This works with a duplex unit and a manual turn over.

--
Mary Sauer
http://msauer.mvps.org/

"Judy Gross" Judy wrote in message
...
OK, I've tried this and everything else I can think of. What I'm getting,
most recently after trying Shelley's fix, is one copy of the postcard with
its corresponding reverse side. It is reduced in size so that the postcard
front covers 1/16 of the page in the top left corner, and the postcard back
is next to it, so all together is takes up 1/8 of the top left of the page.

The print preview shows full sizes on the page, but the print comes out
reduced.

I am printing to a Xerox Workcenter 7132.

In Publisher 2003 I had no problems printing the two sided mail merge
document.

Thanks for any help you can give.

"Shelley" wrote:

I couldn't get templates to print correctly either, but I finally figured it
out.

Design your postcard. Do your merge. Your postcard should be two pages. One
page with the design and the other page the mailing information. The key is
in the print set-up, not the merge.

Select: "Print Merge."
Select: "print multiple pages per sheet"
Paper Size: "letter"
Orientation: "Landscape"
2-Sided Printing Options: "two-sided, flip short side"

The result is an 8 1/2 x 11 paper with two post card designs along the left
and two DIFFERENT addresses (a,b) along the right on paper side. If you flip
the paper over, like turning a page in a book, you have postcard designs
along the left again and two more different address (b,c) along the right.
When you cut them, you get 4 postcards with the same design on one side and 4
different address (a, b, c, d) on the other.

Finally success!

Shelley


"budnspuds" wrote:

Thanks Mary!!!

I will do that. It sounds like it will be much easier. I appreciate
your help!

"Mary Sauer" wrote:

Create two publications. Printing both sides of a mail merge is
problematic.

Somewhere in your printer setup will be an option to "flip pages up" or
similar
dialog, you will want to disable this if you are duplexing.




--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"budnspuds" wrote in message
...
Hi,
I read another post that addressed this same question but I didn't find
the
solution to be helpful in my situation.

I created a postcard using a template from Publisher 2007 and modified
it.
I selected the Avery 8387 page size as I am using the Avery postcards.

I then created the postcard (front and back) and then did a mail merge
using
an excel sheet. Everything looked great and all the names were showing
up.
When I go to print, the same name shows up on all 4 postcards.

My printing selections are "Multiple Copies Per Sheet" and I end up
getting
4 of the front which is ok but the back side of the postcard shows all
4 with
the same person.

I am totally frustrated because I am also struggling with my Canon
Printer
putting the back side up side down.

So maybe I should ask if there is a way to print all of the back side
of the
postcards with the mail merge seperate. Then manually flip them over
and
print them in the right direction and print off the front sides?

Thanks so much! I offered to do this for someone and it needs to go
out
soon.

Shawn