Go to Edit Recipient List and uncheck the blank rows. If you need to leave the spaces in your Excel file, you can just tell Microsoft Word to ignore those blank rows. Having blank lines in your Excel file can mess up your mail merge. Word Is Merging The Blank Rows In My Excel File If you’re using a different barcode font, check to see what alternative leading and trailing symbols there are for your barcode.Ħ. Asterisks usually mean something needs to be bolded and can confuse Microsoft Word.
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.
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. If you select Delete After Message Is Processed on both the Word Mail Merge and Convert actions then the temporary files will be cleared once the message is sent and the Trigger actions have completed.It’s easier to do mail merging in Microsoft Publisher, but it’s possible to do a nice mail merge in Microsoft Word.
The Send Message action could then be used to send the PDF file as an attachment back to the customer. The Convert Word/Excel Document action could then be used to convert the new Word Document to a PDF File. The Word Mail Merge action could run, assign the new document name to a variable. This Action could be used for example to create a PDF Receipt to send to a customer based on fields extracted from an email. This can be a fixed value or any ThinkAutomation Field, Variable or Built-in Field. Specify each mail Merge Field and the Value to assign the field to. Click the Get Fields From Word Doc to extract mail merge fields from any Word Document. You must then map the Word Document Merge Fields to ThinkAutomation fields/variables. Select Delete After Message Is Processed if you want ThinkAutomation to delete the file after it has finished executing all actions for the current message. Select the variable to use from the Assign Saved Path & Filename To Variable dropdown. The merged document path & filename can be assigned to a ThinkAutomation variable.
In the Save To Folder specify the folder to save the new document in. If no Save As name is specified then the original document will be saved. You can use the special %filename% replacement to use the original file name in part of the new filename. In the Save Merged Document As enter the new name for the merged document. Specify the Word File or select Mail Merge Attached Word Documents and enter a File Mask to use any Word Documents attached to the message. The resulting merged document is then saved. This action takes a Word Document and replaces all the mail-merge fields in the document with ThinkAutomation field or variable values. Performs a mail merge on a Microsoft Word document or Word Attachments and saves the merged document as a new file.