Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-16-2015, 11:54 PM
fairchance fairchance is offline Mail Merge with Avery 8387 Windows 8 Mail Merge with Avery 8387 Office 2010 64bit
Advanced Beginner
Mail Merge with Avery 8387
 
Join Date: Jun 2015
Posts: 54
fairchance can only hope to improve
Default Mail Merge with Avery 8387

Dear Friends



Greetings

I want to perform Mail Merge with Avery 8387 Postcard (4 piece per page). when i used label merge option with the following scheme:

Address Block Next Record Address Block Next Record
Address Block Next Record Address Block Next Record

It works on Page No.1 fine as it took first four cell of required column in excel file. When i goes to next page it start from second cell to fifth cell instead of starting fifth cell to eight cell. May be it is very simple but i am stuck this time. Please help.

Screeshots attached:

Page 1: http://prntscr.com/7to82z
Page 2: http://prntscr.com/7to8b7

here is video

http://screencast.com/t/oQdZRVeW2I

Regards

Shehbaz H.
Reply With Quote
  #2  
Old 07-17-2015, 12:27 AM
macropod's Avatar
macropod macropod is offline Mail Merge with Avery 8387 Windows 7 64bit Mail Merge with Avery 8387 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your description suggests you've done the mail merge main document setup for a letter merge instead of for a label merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-17-2015, 01:29 AM
fairchance fairchance is offline Mail Merge with Avery 8387 Windows 8 Mail Merge with Avery 8387 Office 2010 64bit
Advanced Beginner
Mail Merge with Avery 8387
 
Join Date: Jun 2015
Posts: 54
fairchance can only hope to improve
Default

When I choose template with label it generate message " In order to apply the selected label options, word must delete the currents of file.
Reply With Quote
  #4  
Old 07-17-2015, 01:32 AM
fairchance fairchance is offline Mail Merge with Avery 8387 Windows 8 Mail Merge with Avery 8387 Office 2010 64bit
Advanced Beginner
Mail Merge with Avery 8387
 
Join Date: Jun 2015
Posts: 54
fairchance can only hope to improve
Default

I have tried to apply with blank page with 4 label per page layout but result is same. Issue unresolved
Reply With Quote
  #5  
Old 07-17-2015, 01:47 AM
macropod's Avatar
macropod macropod is offline Mail Merge with Avery 8387 Windows 7 64bit Mail Merge with Avery 8387 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

All you need do is choose 'Labels' from the 'Start Mail Merge' dropdown, then press Esc when prompted for the label type.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 07-17-2015, 02:10 AM
macropod's Avatar
macropod macropod is offline Mail Merge with Avery 8387 Windows 7 64bit Mail Merge with Avery 8387 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: http://www.techsupportforum.com/foru...ml#post6471226
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 07-17-2015, 04:15 AM
fairchance fairchance is offline Mail Merge with Avery 8387 Windows 8 Mail Merge with Avery 8387 Office 2010 64bit
Advanced Beginner
Mail Merge with Avery 8387
 
Join Date: Jun 2015
Posts: 54
fairchance can only hope to improve
Default

Dear Sir,

Sorry for cross-post i shall careful in future. Issue is still exist you may check this video.

http://screencast.com/t/RAjHWqp5B

Regards
Reply With Quote
  #8  
Old 07-17-2015, 04:43 AM
fairchance fairchance is offline Mail Merge with Avery 8387 Windows 8 Mail Merge with Avery 8387 Office 2010 64bit
Advanced Beginner
Mail Merge with Avery 8387
 
Join Date: Jun 2015
Posts: 54
fairchance can only hope to improve
Default

Sir, what is the trick? Why the desired output being received. Please give me the solution through video if possible.

Kind Regards

Shehbaz H.
Reply With Quote
  #9  
Old 07-17-2015, 05:39 AM
macropod's Avatar
macropod macropod is offline Mail Merge with Avery 8387 Windows 7 64bit Mail Merge with Avery 8387 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The problem is that you are only do a Preview of the merge - you need to Finish it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 07-17-2015, 08:05 AM
fairchance fairchance is offline Mail Merge with Avery 8387 Windows 8 Mail Merge with Avery 8387 Office 2010 64bit
Advanced Beginner
Mail Merge with Avery 8387
 
Join Date: Jun 2015
Posts: 54
fairchance can only hope to improve
Default

Thank You Sir,

My issue has been resolved now.

Regards

Shehbaz H.
Reply With Quote
Reply

Tags
mail merge



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge with Avery 8387 Mail Merge is Deleting objects in my header and footer during the merge bgranzow Mail Merge 9 06-05-2015 05:03 AM
Is data merge and mail merge the same thing? ikearns Mail Merge 1 09-12-2014 03:53 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Mail Merge with Avery 8387 Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Mail Merge with Avery 8387 Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft