'Replace the paragraph breaks with a field end marker '|' 'Replace any line breaks in the cell with paragraph breaks 'Check each table in each section of the document Please wait until the task completed message is displayed', _ MsgBox 'With a large label file, this macro will take a long time' & vbCr & _ 'The process could take a while, so warn the user Insert merge fields in Word by going to Mailings Insert Merge Field.ĭim oDoc As Document, oNewDoc As Document Then, Mailings Select Recipients Use an Existing List Open the sheet. In Word, select Mailings Start Mail Merge choose type. Prepare for the merge by organizing the data into one Excel sheet. I have been trying to mail merge an excel document into a Word document to make labels and keep getting the message that says 'This file needs to be opened by the Excel Workbook text converter, which may pose a security risk if the file. Question: Q: Mail merge not converting excel document I just updated to the new Yosemite operating system.Note: A sheet of mailing labels is laid out as a table in Word. Use the Next Record rule to tell Word to proceed to the next record without starting a new page. For example, you're using mail merge to print your contact list on a single sheet of paper.While I respect your right to do so, please be aware that the minimal advertising on this site helps defray the cost of providing this facility, and I would therefore ask that you turn off the blocker while browsing this site. You appear to be using ad blocking software.
0 Comments
Leave a Reply. |