If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Postcard mail merge troubleshooting?
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 |
#3
|
|||
|
|||
Postcard mail merge troubleshooting?
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 |
#4
|
|||
|
|||
Postcard mail merge troubleshooting?
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 |
#5
|
|||
|
|||
Postcard mail merge troubleshooting?
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 |
Thread Tools | |
Display Modes | |
|
|