User Profile
Doug_Robbins_Word_MVP
MVP
Joined Nov 20, 2021
User Widgets
Recent Discussions
Re: Keep table rows together
Modify the Paragraph Format of the Table Grid Style and click on the Set as Default button before dismissing that dialog by clicking on OK. To access that Style, put the selection in the table and then press CTRL+SHIFT+S to display the Apply Styles dialog in which the Table Grid style should appear as the Style in use. Click on Modify in that dialog to access the dialog via which you can modify the Paragraph Format.Re: Sending out E certificates
Better late than never. Use my Merge Tools Add-in that is contained in the MERGE TOOLS ADD-IN.zip file that you can download from: https://mergetoolsaddin.com/ Extract the files from the archive and read the: “READ ME – Setting up and using the Merge Tools Add-in.pdf to see how to install and use the various tools. Using those tools, it is possible to perform the following types of merge that cannot be done with Mail Merge “out-of-the-box”: Merge to e-mail messages either with or without attachments, with the documents created by the merge being sent as either Word or PDF attachments or as the body of the e-mail message . The email messages can, if necessary, also be sent to CC and BCC addresses and the subject of the message can include data from a field in the data source. Merge to individual documents in either Word or PDF format with the filenames being supplied by the data in one of the fields in the data source Many to One type merges, which can be used for creating documents such as invoices where there are multiple records in the data source that have common data in one of the fields Merging to a document that will include a chart that is unique to each record in the data source Merging a document with Content Controls Merging a document that contains Legacy FormFields Duplex Merges Merging to a printer that will collate and staple the output created from each record in the data source. The requirements for using the system are: The mail merge main document must be of the Letters type, though that does not mean that the output cannot be sent as an e-mail message where relevant. For the Many To One, Merge with Attachments and Merge to Individual Docs utilities, the data source may be either a table or query in an Access database, or in the form of an Excel worksheet. For the Chart Merge utility, see the Mail Merging with Charts document that is included in the Merge Tools Add-in Zip file for additional requirements for the data source for use with that utility For a data source in the form of an Excel worksheet, the field names must be in the first row of the worksheet and there must be a field name in all of the cells in that row that are within the range of columns that contain the data. For both types of data source, the field names must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9). The number of characters in the field names, including spaces, must not be more than 40. The MergeTools Add-in will NOT work with the “New Outlook”, which is just a re-badged version of Windows Mail and like its predecessor, it does not support automation and hence will not send the messages created by the MergeTools Add-in. Be aware, that any messages that you had tried to send with the “New Outlook” will have been placed in the Outbox of the original Outlook and they will be sent as soon as you revert to that version of Outlook. If you do not want that to happen, you should put Outlook Off-line, or disconnect your computer from the Internet. For a demonstration of the use of the facility, prepared by a Microsoft employee, see https://www.youtube.com/watch?v=yj_s3cdfVDY https://www.youtube.com/watch?v=GGXZ3aQN7ooRe: Mail Merge malfunction
To deal with the UK issue, use the following field construction {IF {MERGEFIELD Country} = "United Kingdom" "" {MERGEFIELD Country}} You must use CTRL+F9 to insert each pair of field delimiters { } and use ALT+F9 to toggle of the display of the field codes. When you execute the merge, it will automatically index through the records WITHOUT needing the Next Record field.Re: Add style to headings sidebar
Use one of the levels in the multilevel list and the related Heading # style for the un-numbered headings. Re editing your post, if you click on the ellipsis at the top right of your post, you should see an Edit item, which is what I did here to add this to my initial response.Re: Table of contents bug - num list headings are on multiple lines in the TOC
An un-redacted screenshot would be a lot easier to interpret. However, even then it may not be possible and it is likely that the issue is with the relevant "heading" in the body of the document and it will probably be necessary for you to provide a copy of the document to enable us to provide you with a solution for the issue.Re: Group objects
Grouping of objects is a common cause of mis-matched xml tag errors and I always recommend that compiling of such images\objects is best done outside of Word, or in a separated document, and then a screenshot is made that can then be inserted into the document with layout set so that it is "in-line with text".Re: Drop down menu linked to an Excel file
See the following pages of Greg Maxey's website : http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm http://gregmaxey.mvps.org/Customize_Ribbon.htm See the "Cascading Listboxes" section of the following page of Greg Maxey's website: http://gregmaxey.mvps.org/word_tip_pages/populate_userForm_listbox_or_combobox.html
