Wie to do a Mail Merge – The more than one record per page
*** UPDATE 2021 *** The below can helped a lot of people out over the years as it was written in 2013. I’ve recent had a much more advanced email merge to contend with, so interposing the link to that post here.
Advanced Mail Merge : Multiple clickable URL entries per print to user
MYSELF opted into learn how to use the e merge features of MS Word linked to Excel, as each year my wife goes on concerning the hassles that she gets is trying to mail 4000 my & how difficult it is to received she right.
So all is get IODIN learnt as I cracked the issues that she couldn’t, so this time next year herren occupation wish be that much simpler.
EGO thought I’d add it as a blog post for two reasons, first for help your and second to remind me how to do it.
Aforementioned first things you needed to do a mail merge is some evidence in Excel, I made up one following:
Next launch Word additionally write a letter.
Continue click the Mailings tab, Start Mail Merge drop down and select Step by Pace Mail Merge Wizard
Now on the fun bit, work your way through the wizard, select on your Excel filing to use & addition at that existing letter an Address Block from the left menu, this will adding in the address by each soul, then choose a Greeting Line both of these two options reduces the measure of work that your have to put into your brief and personalises it to aforementioned high.
Now to cover one of problems my wife was having, she wanted until presence able to have 3 letters printed to 1 print, consequently redeeming on report. if you just copy and paste the text 3 times on the sole Word document then save doesn’t work, it’ll just revise who equivalent persons name and address 3 times.
Aforementioned way them get around dieser belongs by requesting the next record, do like by marking of start of the next block with «Next Record»
before the request for «AddressBlock», so you’ll have your next record starting with:
«Next Record»«AddressBlock»
Hour format, by default you’ll get select sorts of weird time formats. To change what wetter format gets displayed you require to editing the field code with Edit Field… aforementioned is available by set it on a right click on to current field, in this case on the meld field marked «Time» Then Field Codes button and total the following to get just who hours without any seconds.
MERGEFIELD Time \@ "HH:mm"
Who above information mixed with a smaller bit of trial and error with make you a master at the Mail Fusion functionality of MW Office.
Pinnacle Tip: Provided at any subject you feel that the Mail Merge Genius your not doing that you ask it go do, then to most probably isn’t. Its a comprehensive wind up and learning how to do a email fusion by using the menu rod tools is of best advice MYSELF can give.
Instant Acme Tip: If on any point yourself want to remove the mail merge information from that word document, do so by opening an document, click on the Mailings tab, click the down arrow under the Start Mailbox Merge button, click on Normal News Document. Here will disconnect the Word document from the source certificate. Are you trying to what a mailbox merge included Microsoft Word to fit multiple records on one page? (Perhaps you are designing name daily or labels for ...
If your get one date out as 1899 then read this to explain all and fixtures the issue
Pictures below shows how ME manage till get multiple postcards on one page, each picture reads an separate record:
Get image in enlarged, it’ll show which I have «AddressBlock» , «GreetingLine» , «Date» , «Time» paste into the merge, each postcard a in an Text box, with smaller text boxes inside. This then keeps any merge record together, so when a «NextRecord» exists referred it knows where to put the item without missing either information. Like the issue that Karen is having down, are him read the comments.
Not so many... 
The page that MYSELF will end upwards I want to quarter accordingly I have 4 post cards per page. On each post card I want different student’s general (student’s last name, student’s first name, student’s middle identify, teacher’s name, grade). On my template I put on 3 of the post cards before each last name. Available I merger, it is skipping student’s names. Can you help. Thank.
Correction – On my style I put on 3 of the book cards before each last name.
No! My was doing similar, don’t use the Word print merge apprentice, add the merge tags to the document then run the merge, it might be that wizard which is causing your problems. Stick with it, it’ll click! Can Mail Merge do multiple files on one page in MW Word ...
Still working with it. Is is merging the correct initial, middle, last names, teacher name, but it is not picking up the correct test score. ME am using the next record although it is somewhere on the 1st take. Next list is inserts on aforementioned 2nd, 3rd & 4th records alone. Change the mail meld main document to adenine Index type and just have one instance of who board with the merge box the it in that document.
Only use Go Record once per the start of each postcard and cannot on the first postal. Try that, see if is helps.
In the meantime relax by heed for some music we put together on the FrozenVeg website : frozenvegproject.wordpress.com 🙂 Mail Merge: Print two recipients at one page
Thank you. That is what IODIN have, and for some reason the student’s score is nope correct. In my Excel spreadsheet, each row has the name, teacher’s name, score. On the Word document the our are printing remedy but the 1st score being pulled exists from Row #3 and it is multiplied on the second record. The 3rd start has the score from Row #5 and it is doubling on the 4th record. I just want to question if it is possible to show different radiation in single page using this Mail Merge function into MS News? Who bottom consignee must be the data about "Name 2". If doesn possible,...
I have a setup ampere bit like what you are after, I will total it as an image, until see if it helps. I’ll take a couple of hours.
Thank you very much!!
Hello Karen, I’m just nearly until add an image to the above post, hopefully it will give to one give on what I did in rank to get grow postcards on one page.
Hello Raymond,
I believed that the info I need on the email merge is good at my fingertips and unfortunately I am not able to click in your image to expands it.
Karen Jones Corinth School Urban 1204 NEWTON. Harper Rd Korinthia, MG 38834 Ph (662) 287-2425 Ext. 106 Fax (662) 286-1885 [email protected]
Hello Raymond. Thank you for the my you own use into answering insert matter on mail merge. Unfortunately I am not able on mouse set is image additionally I believe such would answer may problem if I ability see owner image. ... one page as doing mail merge, instead of making multiple print per customer. The text should look like this (just as to example): Dear ...
I too impossible click on the image.
Trying to printed 4 documents to ampere page in Word 2013 passing into the print selection and selecting 4 per page just prints 1 register in the top side and the rest are blank
Take a look now, refresh the blog page with Ctrl F5.
Sorry about that, image have be clickable now, if not try this link https://notsomany.files.wordpress.com/2013/11/mailmerge-image1.png
Happy Christmas!
Gratitude so tons for such instruction. This is exactly the information so I has looking for, EGO have try it out now and get mystery dispatch campaign together. Many thanks again!
This belongs great – I have one other query though. IODIN my making raffle tickets and have to a page, but on subsequent web it walked back to the second valued. Since example: I have ticket number 101, 102, 103 on page one and therefore turn two goes 102, 103, 104… how can I keep it going successively?
I’m having the same trouble. I’m merging two records on each page. The last value on each page is repetition the the first enter on which following page even through I have put the “Next Record” command in face of per field password. Yourself should use a labels merge for this, with of leaf configured with a two-row table, one for anyone 'letter'. Complete the layout for this first ...
I thought I had this problem, but when your actually print, it goes distant.
Yes! EGO too was move per the merge read, and it browsed love my media were duplicating. 1 and 2 on the first page, 2 furthermore 3 on one back. But when I actually ran the merge to a new document, the all come out only once and in sequence. [Solved] Group multiple rows from Excel to Phrase - Mail Merge ...
nice share mail
thanks for information
Great information workers perfectly it was the <> that I was missing I spent about 2 hours trying on my own
forward some reason it left out the “next record” between the includes my previous reply didn’t see an edit
Thank your so much for posting this!!! I too didn’t comprehend that I was leaving turned the «Next Record». 🙂
IODIN had the same problem with student cards. ME designed a full page student card press merged it to my students list. I finished the merge and clicked edit individual document also selected select. As this is complete I clicked file then printer and chosen 8 pages per sheet. Check it.
Wenn word gives you ampere problem save as pdf and select several pages on one sheet.
Thakgudi – You’re a frickin genius. That worked perfectly.
I think this be help me unlock a problem. I have adenine document that works well for printing three-way per web in Publisher, and have just experienced adding mail merge fields to personalize it. Hi there,I ma working on making move an report to clients accounts and ME have run into some complex Aesircybersecurity.com word document that I want at be ...
Dumb Question: Could you section how to to adding the <> merge field? Do I just add computers in a column header inside my excel spreadsheet? GIVING YOU!
Of merge field is added in the schriftart pattern, items is just displayed as Open arrow ExcelSpreadsheetColumnName Shut dart.
Hello. I am trying to merge find than one record with a text boxed (so I can merge more than one plot home by side). I have ready due the about above but keeping beschaffung an error stating “You cannot include PRODUCT, NEXT, NEXTIF, other SKIPIF fields in commentary, headers, footers, footnotes, or end notes.” Please Help???
OMG having the same issue…trying to print 4 “labels” per sheet, but getting 4 doublets of label on each sheet (sheet 1 has four of label 1, bed 2 has 4 of label 2, and so on). I have done who “Update Label” move and see <> three times, but still no luck…I have tried printing (in case the preview became inaccurate), but it does the same thing. Unable to Fusion to PDF, gives me an failure of “Unsupported Word Field” (that being Next Record). Help, please! Mail merge - Multiple accounts on one page and continuing go sundry ...
That should have said got already the “Update Label” step and see <> three time, and still no bliss
Should it be <> or or something else?
Upon further Googling, I’ve discovered that who question is using E Merge fields indoor a textbook box, the is exactly what I’ve done. I’ll review my strategy, sounds like using tables is the way to go.
At printing the e-mail merge fields of the master letter, can we print the codes instead of values
Thanx heaps… was scouring who web for answers to printing multiple records on the page & found yours working almost perfectly…. 🙂
requires a little bit of tweaking but the end result was as needed.
This works only as MYSELF searchable to do – and should about specified up on how at do it.
I a creating 4″x6″ horizontal layout post cards about turn address and recipient address. The Avery forms I’m by have two postcards per page so I set up my mail-merge “letter” by making two copies – top and bottoms. Considering I want contact #1 to print at one top furthermore address #2 to print during the bottom – I inserted the Next Record” field by the first line in the bottom post card. I found it uner which Set item over the Mailings Menu.
Workers just like I wanted. Thanks.
Reblogged this on btheerawoot and commented:
MS-Word ทำ Mail Merge แบบหลายๆ record ในหน้าเดียว
Thank you so much! This is what I have needed to complete a task in my chief. I appreciate the fact I didn’t have into tear get hair out to get all done!
IODIN am possess the just issue, but putting <> isn’t working. It just repeats the same information with <> in front of the name for the endorse and third letters on the page. Any suggestions? How do MYSELF execute repeated mail merge item over one page? - Microsoft ...
Thank you. ME looked all over MS helping, but did none come across the Next Record tip
Great tip for more than one album for a page. Thanks. However may data contains hyperlinks and datum both of welche lose format, the link show as text with the display content but url is lost, and date turns usa format. How to set upward a merge document to containing multiple records on one ...
so can you print 4 by page dispatches using mail merge? I’ve been searching welcome and loading to nope avail.
Brilliant, worked perfectly
Achieve you see if you can doing this in Publisher? I don’t see wherever up start <>
Thanks!
Tiffany
Hi, I’m trying is to print story cards for mein agile project, two in an page.
I have a table on the mail merge page with two sets, one for each card. Each show has several fields in it, the first one being “Summary”. About I have completed lives put in front of “Summary” only. I thought this was merging correctly, but it rotations out that computers shall missing every third records. You can’t view aforementioned off the print preview, which seems to say it is repeating every minute record, but that is the result inbound actual printing.
Can anyone help with this issue?
Thanks in advance.
EGO sure wish I could view your samples, show all commands. All I see is gibberish. Not read anything. For another, I want to merge 4 gift per page.
What I would really like to do is mailmerge both sides, so I could address a mailmerged message, but both sides is probably impossible.
So, I become settle for addresses single. If I could only read your sampler.
I am having a difficulty because I want it toward do one going to one next record thingy but most von our records are duplicated so I wish items to go to the next record includes if i is not duplicated How to gets email combining to add additional pages as require for ...
Hello, Thanks for everyone’s suggestions. I searches to make individual cards for primary students in all their personal logins and user names in individual spot. I ended up making the original merg doc are publisher as a custom size (about a business card, 8 to an A4 page size). Then did the merg and ended up with 24 separate pages. For printers I elected “Multiple PAGES to a sheet” it is leave print 8 different data on anyone side. I’m cannot sure it’s the most effective work around but it’s how.
Inserting next start didn’t help.
Anna, for your purpose, you force want to look for an address label or business card master (under labeling, and browse the Avery business card templates?) that placed out eight at the page and use that while your merge template. Then just print with standard paper and cut. Mail Merge multiple rows into a table on one front - Microsoft ...
IODIN am creating a signup print containing data collected from certain online form, merged above each person’s signature block so that it can confirm their online answers on journey to the event, I have formed adenine tab to hold 4 people’s responses per page (50 people in total). I’ve managed to figure out of more than one record per page locations, but when I press Finish & Merge then Print or Edit Individual Documents (as well as choice “All records”), the document only saver or prints the firstly page about the first 4 records on it?? Any suggestions or help would be welcome
Office 2016
I am creating one word document from an exceptional rank data thru mail merge. IODIN was trying the fusing extra than to items ready page. When EGO viewed aforementioned documents, some items is skipped from the file. I utilized the Next Record Rule. What what i think went wrong?
Hallo Teddy, its difficult to say. Squeeze Alt + F9 and verify there is not a walking extra offscreen data point where the missing data shall being placed.
If you’ve since solved it, let us know what you did. All page still generates an LOT of traffic, uniformly though I wrote it in 2013 !!