Microsoft Office Forums Mail merge issues not covered in long post

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2016, 05:41 PM
idzineit idzineit is offline Mail merge issues not covered in long post Windows 7 64bit Mail merge issues not covered in long post Office 2013
Novice
Mail merge issues not covered in long post
 
Join Date: Mar 2016
Posts: 3
idzineit is on a distinguished road
Exclamation Mail merge issues not covered in long post

I am doing a mail merge of a 2-page letter, where the graphics elements have been inserted behind the text and locked. The document is an awards notice for a university and contains many fields, some with variable amounts of text.



My issue came up when I did a preview and noticed that the name and amounts which should have come up name...amount... amount, came up vertically stacked...

Most of the columns worked, but they have supplied a CSV file and I cannot see what is actually supposed to go where...so I have no way to check...

How do I insure that a multiple line variable, will print out the numbers that correspond to it correctly?

Did this make sense?
Reply With Quote
  #2  
Old 03-13-2016, 06:54 PM
macropod's Avatar
macropod macropod is offline Mail merge issues not covered in long post Windows 7 64bit Mail merge issues not covered in long post Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 beholdmacropod is a splendid one to behold
Default

Without seeing both the mailmerge main document and some representative date, it impossible to diagnose the issue. Can you attach your mailmerge main document and some representative data to a post (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
  #3  
Old 03-13-2016, 07:49 PM
idzineit idzineit is offline Mail merge issues not covered in long post Windows 7 64bit Mail merge issues not covered in long post Office 2013
Novice
Mail merge issues not covered in long post
 
Join Date: Mar 2016
Posts: 3
idzineit is on a distinguished road
Default Here are the 2 docs

I've attached the 2 documents when I tested by exporting to a pdf, you can see that under the gift, all the numbers starting stacking. I noticed in the csv file that a few categories had multiple entries. I'm wondering if this is the issue as they clumped a lot of the gifts under this one field.

Your help is sincerely and most graciously appreciated.
Donna
Attached Files
File Type: docx UMFlint_MasterdocLetter1.docx (262.8 KB, 3 views)
File Type: doc glrletr_3211515.doc (2.2 KB, 3 views)
Reply With Quote
  #4  
Old 03-13-2016, 11:06 PM
macropod's Avatar
macropod macropod is offline Mail merge issues not covered in long post Windows 7 64bit Mail merge issues not covered in long post Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 beholdmacropod is a splendid one to behold
Default

The core issue is that, for your data source's data structure to work, your mailmerge main document needs to use tables for the tabulated data. See attached.
Attached Files
File Type: docx UMFlint_MasterLetter.docx (280.9 KB, 20 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-14-2016, 10:23 AM
idzineit idzineit is offline Mail merge issues not covered in long post Windows 7 64bit Mail merge issues not covered in long post Office 2013
Novice
Mail merge issues not covered in long post
 
Join Date: Mar 2016
Posts: 3
idzineit is on a distinguished road
Default OMG thank you

Paul, you have saved my life with this... I was under the gun and have never used any table type formats in word for merge... Thank you so much.!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert picture as a header with mail merge (resolution issues) sanpedro Mail Merge 2 02-03-2015 09:54 PM
Publisher 2013 Mail Merge Issues josheridan Publisher 0 10-23-2014 07:21 AM
Directory Mail Merge Issues dbpros_crm Mail Merge 10 01-20-2014 11:05 PM
Mail merge issues not covered in long post Listed items covered in a block of grey. Microsoftenquirer1000 Word 1 02-03-2013 11:40 AM
Publisher Catalog Merge - Long Date Jazz43 Publisher 0 09-23-2011 03:59 AM


All times are GMT -7. The time now is 03:58 AM.


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