This lets you multiply the number coming from Excel by 100 before formatting. To do it embed the MERGEFIELD inside another Word field.
You can change the decimal fraction (eg 0.738) to a percentage (73.8) in Word. Normally, a Word mail merge will import the raw number from Excel and let you format it in way we’ve described before.Īs usual, there’s more than one solution to the problem: Formatting in Word For example 25% is stored in Excel as 0.25. Not affiliated or endorsed by: MICROSOFT WORD and MICROSOFT PUBLISHER are registered trademarks of MICROSOFT INC.How can you put percentages into a Word mail merge?įollowing our article on importing Excel data into a Word mail merge, here are the options for using percentages.Įxcel might show a percentage but the number stored is a fraction. Have you run into any other problems with mail merging in Microsoft Word?ĭo you want to use mail merge start to printing your own postcards? Check out our products below Cut the merged field out then paste it where you want it to be. Make sure you have highlighted all of the merged field (“>”) including the ’s. Moving merged fields might seem like a touchy issue, but it’s really no different than moving regular text. Try not to use text boxes when mail merging with multiple copies of a Merge Field on the same page. You can’t put rules (like the Next Record rule) in text boxes. First Record Works But Second Record Does Not Work in Text Box
Windows mail merge from excel code#
Use parenthesis instead of asterisks for Code 39 barcodes in Microsoft Word. Code 39 Leading & Trailing Asterisks Not Working Change the line spacing to 0 (might have to use 0.06 or similar)ĥ.Highlight the paragraph offending symbol.To get rid of an extra page that won’t go away when you place the cursor at the beginning and hit Backspace: There’s an Extra Page at the Bottom Of My DocumentĪs mentioned before, Word likes to insert spaces.
Clicking that will bring up the Mail Merge Wizard to help walk you through creating your mail merge.Ĥ. If you go to Start a Mail Merge and look at the drop down you get when you click it, “Step by Step Mail Merge Wizard…” will be the last option. Sometimes the Mail Merge Wizard will not launch automatically. Started The Mail Merge But Don’t Know What To Do Next This will force Word to go to the next record.ģ. Use a Next Record rule beside each instance of the merge field that you want Word to move to the next record. Having multiple copies of the same merge field on the same page can cause the first record to be repeated in all instances of the merge field on that page. Make sure any leading and trailing characters are right next to the merged field and don’t have any spaces between them and the merged field. If your barcodes aren’t working correctly, check for extra spaces around the merged field. Microsoft Word can sometimes add in extra spaces where you don’t want them.
Windows mail merge from excel how to#
We’re going to look at some of the most common problems and look at how to fix them. Since Microsoft Word looks at all of the pages as a whole vs Microsoft Publisher which looks at a single instance of your project, some problems can arise in Microsoft Word when mail merging. It’s easier to do mail merging in Microsoft Publisher, but it’s possible to do a nice mail merge in Microsoft Word.