Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-12-2014, 01:46 AM
ikearns ikearns is offline Is data merge and mail merge the same thing? Windows 7 64bit Is data merge and mail merge the same thing? Office 2010 64bit
Novice
Is data merge and mail merge the same thing?
 
Join Date: Sep 2008
Posts: 4
ikearns is on a distinguished road
Default Is data merge and mail merge the same thing?

Have been going through a few tutorials and seem to be finding a lot of good information but nothing which really matches what I am intending to do.



I have a spreadsheet with data about films. It includes the name of the film, the rating, the duration, a brief summary and also the genre of the film. I am hoping to put this information into an easy to read document for my father so it can be printed and he can read it as a 'brochure' type catalogue and choose whatever film he wants to watch.

Ideally the entries in the Word document will be tabular and standardised so that he becomes familiar with the layout.

Can anyone give me any pointers on how to get started?

TIA
Reply With Quote
  #2  
Old 09-12-2014, 03:53 AM
gmayor's Avatar
gmayor gmayor is offline Is data merge and mail merge the same thing? Windows 7 64bit Is data merge and mail merge the same thing? 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

If you can put all the data for a film in a single row Word table (perhaps in landscape mode), you should be able to use http://www.gmayor.com/ManyToOne.htm to create a report with a table that contains the records one to a line. You will probably have to add a key field to your data to ensure that the records all go in the one table (see the example that comes with that add-in).

Another ploy that does not entail any addition to your data is to run a Directory merge with your data to a new document then add the common text to beginning and end. A directory merge repeats everything you put on the page for each record, and immediately following the last.
__________________
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 how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Is data merge and mail merge the same thing? mail merge using data from column A as placeholder. keys Mail Merge 2 10-31-2013 01:55 AM
Is data merge and mail merge the same thing? Collation of mail merge data Nibbles Excel 2 04-16-2013 07:59 AM
Is data merge and mail merge the same thing? Mail Merge - If a field is black, take the data from the row below? mikeprent Mail Merge 5 01-05-2012 04:52 AM
Need help creating a data base for mail merge. acedking90 Mail Merge 0 07-27-2009 11:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:15 PM.


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