Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-23-2014, 07:51 AM
bgranzow bgranzow is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2014
Posts: 12
bgranzow is on a distinguished road
Angry Mail Merge is Deleting objects in my header and footer during the merge

HELP!
I am running Word 2013 and Windows 8.1. I am using Mail Merge to create spec sheets for products. However, when I initiate the merge, no matter if I merge all of the records or an individual record, the resulting documents are missing some but not all of the objects in my header and footer. The header contains merge fields, a shape, and two pictures. The shape is the only thing from the header to disappear. In the footer, there is a text box and a shape. Both the text box and the shape disappear. I cannot figure out why this is happening. Any advice is greatly appreciated. Thank you.
Reply With Quote
  #2  
Old 06-23-2014, 03:58 PM
CathClaud CathClaud is offline Mac OS X Office 2008 for Mac
Novice
 
Join Date: Jun 2014
Posts: 9
CathClaud is on a distinguished road
Default

this sounds like a bad paragraph mark in the main doc - or else the merge is replacing the paragraph mark in main or header or footer causing items to "disappear"
Reply With Quote
  #3  
Old 06-23-2014, 06:05 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,799
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by bgranzow View Post
The header contains merge fields, a shape, and two pictures. The shape is the only thing from the header to disappear. In the footer, there is a text box and a shape. Both the text box and the shape disappear. I cannot figure out why this is happening.
I'd suggest checking what the text box and the shape are anchored to. If they're anchored to a mergefield that could explain the behaviour.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 06-23-2014, 09:24 PM
bgranzow bgranzow is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2014
Posts: 12
bgranzow is on a distinguished road
Default

I looked into both of those solutions and neither of them are the case. There are no missing paragraph marks as far as I can tell. The anchors are not miss-positioned and are anchored to the page, not to a disappearing merge field. Furthermore, I attempted to group the objects with objects that remained in the header and footer. When I did that, all of the objects I grouped disappeared. When printing however, all of the objects are visible.
Reply With Quote
  #5  
Old 06-23-2014, 09:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,799
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by bgranzow View Post
I attempted to group the objects with objects that remained in the header and footer. When I did that, all of the objects I grouped disappeared. When printing however, all of the objects are visible.
I don't understand - are you saying they disappeared from view in the mailmerge output file, but printed anyway?

It would be easier to diagnose the issue if you could attach copies of the mailmerge main document and an output document to a post with some representative data (delete anything sensitive). You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #6  
Old 06-24-2014, 02:02 PM
bgranzow bgranzow is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2014
Posts: 12
bgranzow is on a distinguished road
Default Example of problem

Paul, Ya sorry that was confusing. I meant to say that when I print the original template using a pdf printer, all of the objects appear just fine. However, when I merge the documents, they do not. I have attached the original template and the PDF file that is produced by the completed merge of one record. Notice the differences in the header and footer.
Attached Files
File Type: docx Spec Sheet Template BDA.docx (144.9 KB, 14 views)
File Type: pdf TTRM1008.pdf (431.4 KB, 5 views)
Reply With Quote
  #7  
Old 06-24-2014, 02:05 PM
bgranzow bgranzow is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2014
Posts: 12
bgranzow is on a distinguished road
Default

A couple other clarifications. I know the problem is not in the macro I'm using to complete the merge because it occurs when I use the built in word mail merge function as well. Also, I have "discovered" that it is only the drawing tool objects that are disappearing. Pictures and text are fine but all shapes are disappearing. Does anyone know a solution to that problem?
Reply With Quote
  #8  
Old 06-24-2014, 03:53 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,799
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Your header looks fine to me - the PDF version seems to be the same as in the main document. As for the footer, you could fix that by cutting the content out of the textbox there, deleting the textbox and pasting the content directly into the footer. All you'll need to do then is delete the final paragraph break and change the footer distance from edge page layout settings.

Quote:
Originally Posted by bgranzow View Post
I know the problem is not in the macro I'm using to complete the merge because it occurs when I use the built in word mail merge function as well
I can't comment on your macro because I haven't seen it
Quote:
Also, I have "discovered" that it is only the drawing tool objects that are disappearing. Pictures and text are fine but all shapes are disappearing. Does anyone know a solution to that problem?
Have you checked Word's 'Print drawings created in Word' option?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 04-06-2015, 10:09 AM
tsgjc tsgjc is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2015
Posts: 1
tsgjc is on a distinguished road
Default Did this get solved at all?

Quote:
Originally Posted by bgranzow View Post
A couple other clarifications. I know the problem is not in the macro I'm using to complete the merge because it occurs when I use the built in word mail merge function as well. Also, I have "discovered" that it is only the drawing tool objects that are disappearing. Pictures and text are fine but all shapes are disappearing. Does anyone know a solution to that problem?
I am having the exact same problem to my eye and would like to know if this issue has a solution?
Reply With Quote
  #10  
Old 06-05-2015, 05:03 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,799
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Since you say you are "having the exact same problem", you should try the solution I posted nearly a year ago.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
delete, header, mailmerge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colour code mail merge header table cell backgrounds ScotsMaverick Mail Merge 3 06-13-2014 03:05 AM
Mail merge in a header Kizzy Mail Merge 1 08-13-2012 10:50 AM
Mail Merge using Word 2010 - Header source not be recognized Gage262 Word 8 02-01-2012 11:08 AM
header/footer doc merge mrtinfl Mail Merge 2 12-10-2011 10:33 AM
Deleting records/results from mail merge alexb123 Mail Merge 2 08-12-2011 02:27 PM


All times are GMT -7. The time now is 07:31 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft