Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2015, 07:22 AM
patrickpetersen patrickpetersen is offline Mail merge in sections with address list Windows 7 32bit Mail merge in sections with address list Office 2010 32bit
Novice
Mail merge in sections with address list
 
Join Date: Feb 2015
Posts: 1
patrickpetersen is on a distinguished road
Default Mail merge in sections with address list

Hello!

I'm trying to do a mail merge with several pages.
The letter/mail consists of a minimum of 2 pages:
- Page 1: Front page (Portrait) - Section 1
- Page 2: Appendix (Landscape) - Section 2



It works if I mail merge one at the time, but when I try to merge it all it does this:

Person 1
- Page 1: Front page (Portrait) - Section 1
- Page 2: Appendix (Portrait) - Section 1

Person 2
- Page 1: Front page (Portrait) - Section 1
- Page 2: Appendix (Landscape) - Section 2

--
What I need it to do is:
Person 1
- Page 1: Front page (Portrait) - Section 1
- Page 2: Appendix (Landscape) - Section 2

Person 2
- Page 1: Front page (Portrait) - Section 1
- Page 2: Appendix (Landscape) - Section 2

Person n
- Page 1: Front page (Portrait) - Section 1
- Page 2: Appendix (Landscape) - Section 2

What am I doing wrong?
I've tried to do it like this:

Page 1:
Section break (Continuous)
Portrait mode
[Content]
Section break (Next Page)
Page 2:
Landscape
[Content]

I've uploaded it to my dropbox:
https://www.dropbox.com/sh/bw1qadjja...SbDeyQ-ZMGonWa

It contains 3 files:
- Excel list (Data)
- The letter (Content)
- The result. (Result of metioned use of sections)
Reply With Quote
  #2  
Old 02-18-2015, 10:57 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge in sections with address list Windows 7 64bit Mail merge in sections with address list Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Your attachment was unavailable, however the first section break is superfluous. It should be

Page 1:
Portrait mode
[Content]
Section break (Next Page)
Page 2:
Landscape
[Content]

This will merge to a new document with alternating portrait and landscape pages - or to separate documents with http://www.gmayor.com/individual_merge_letters.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Mail merge in sections with address list mail merge address list disappeared janm Mail Merge 1 08-06-2012 11:41 PM
Mail merge and address book CDTom Mail Merge 0 01-17-2012 09:08 AM
Where is the category or distribution list or group as I add new e-mail address? Jamal NUMAN Outlook 0 11-21-2010 07:34 PM
Artwork with return address & mail merge labels slalemand Office 0 11-11-2010 12:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 AM.


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