Quote:
Originally Posted by JennEx
When I apply my datasource to your revised version of my report ... I have no more blank pages and the Page of Pages fields populate. But, the times are all decimals. This report was a result of merging directly from Word
|
The only way I can see the times as decimals happening is if the workbook is open - which it must be when you use the macro, but needn't be for merging direct from the mailmerge main document. And, if the workbook is open, you need to revert to the kind of field construction used to convert the decimals to hh:mm referred to in:
https://www.msofficeforums.com/mail-...tml#post114362 (minus the \* MERGEFORMAT switches)