Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2012, 10:01 PM
Peterth Peterth is offline Word create a blank page Windows XP Word create a blank page Office 2003
Novice
Word create a blank page
 
Join Date: Jan 2012
Posts: 3
Peterth is on a distinguished road
Default Word create a blank page

I would like to seek your help in troubleshooting a mail merge issue.


I create a mail merge document with the data come from an SQL database. The template has 2 pages, the first page contains mail merge client information, which it works properly. The second page - I am using page break - Section break, and insert the following merge field

{IF { MERGEFIELD A } = {INCLUDETEXT "\\\\DIR1\Doc1.doc" \* mergeformat}}

When the mergefield A is not blank then the document is included (Which is Ok). However, if the condition is satisfied, it include a blank page, which is not right
How can i remove the blank page?

Thanks
Reply With Quote
  #2  
Old 01-05-2012, 02:10 PM
macropod's Avatar
macropod macropod is offline Word create a blank page Windows 7 64bit Word create a blank page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi Peterth,

The blank page is probably the result of something in the document referred to by the INCLUDETEXT field. You might get better results if you bookmark just the part of the reference document you're interested in (eg not including the final paragraph mark) and refer to the bookmark in the INCLUDETEXT field. For example:
{IF{MERGEFIELD A} <> "" {INCLUDETEXT "\\\\Dir1\Doc1.doc" "BkMk"}}
where 'BkMk' is the bookmark name. You probably don't need the '\* Mergeformat' switch.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-05-2012, 07:42 PM
Peterth Peterth is offline Word create a blank page Windows XP Word create a blank page Office 2003
Novice
Word create a blank page
 
Join Date: Jan 2012
Posts: 3
Peterth is on a distinguished road
Default

Many thanks. I shall follow your advise.
Reply With Quote
  #4  
Old 01-08-2012, 09:06 PM
Peterth Peterth is offline Word create a blank page Windows XP Word create a blank page Office 2003
Novice
Word create a blank page
 
Join Date: Jan 2012
Posts: 3
Peterth is on a distinguished road
Default

blank page is produced when the condition is not sastified
Reply With Quote
  #5  
Old 01-08-2012, 09:13 PM
macropod's Avatar
macropod macropod is offline Word create a blank page Windows 7 64bit Word create a blank page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi Peterth,

That suggests the blank page is already present in your mailmerge main document - which is consistent with ' I am using page break - Section break'. The IF test I provided outputs the bookmarked content from the reference document if the condition is satisfied and nothing if the condition is not satisfied.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word create a blank page Page Breaks, Headers, Blank Pages? jnbwolf Word 2 12-21-2011 12:33 AM
Page numberring 1 - blank - 2 - blank etc Intern PowerPoint 0 09-02-2011 01:16 AM
Word create a blank page Problems using word to create web page persist Word 1 04-07-2010 04:39 PM
Unable to delete the last blank page. anandjeevakan Word 0 12-11-2009 05:20 AM
How do you delete a blank page at end? aerophil Word 4 10-24-2009 05:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 AM.


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