WaterlooCOW

I am merging data from an Excel worksheet into a Word document. Although the time data in Excel is formatted as h:mm AM/PM, the same time presented in the merged document appears as h:mm:ss AM/PM. I think I need to use a switch in the merged field to reformat it to the preferred h:mm AM/PM. On the merge document, the field looks like this (after alt-f9) .... {MERGEFIELD "Start_Time"}. I do not know how or where to insert the switch (\@ "h:mm AM/PM)?? Thanks in advance for your help. A simple problem, but one I am struggling with. Jennifer

Thanks Spacesurfer .... What's interesting is that I had already done what you had suggested. I had applied that restriction on all the rows of my table. The table is the base (target merge document) of a directory style mail merge, so the entire table gets repeated several times on the same page with each record it extracts from the database. The last table still breaks apart onto the next page. Could this have something to do with the merging features?

And my final question, for now .... I have 4 different mail merge documents that utilize one common Excel database. These 4 different reports are used independently based on the type of record being imported based on a mail merge recipient query. Is there a way I can automate the process of executing each of the 4 merge reports individually, into one process to provide me with a single combined report? The 4 reports (just a tables) differ only slightly in that some have additional rows, or redundant cells (information needed for one report, but not others). Knowing that, maybe it is an easier option to eliminate having four different documents, and some how automate which cells/rows are used for each row of imported data. Right now, the individual reports are launched from a button macro in Excel. I would prefer to hit one button, rather than 4. Thanks again, in advance, for your consideration and help. Jennifer

In my project, I must include a field in my document stating the number of records found resulting from my mail merge recipient query. How do I determine this value, and include it as a field in my merge document? Thanks in advance for your consideration and assistance. Jennifer

How can I stop my table from slipping apart when it reaches the end of a page. I would prefer the table to be complete on the next page before I accept it being in two parts between two different pages. Thanks in advance for your time and assistance. Jennifer