Thanks Paul ...
Quote:
|
...it's frustrating that one document still generates decimal values for you.
|
No ... when using the VBA code, all (16) reports ... whether the SQL is part or the document or not ... generate decimal time values, even when they don't when performed manually outside of the VBA. A report run on it's own from Word gives positive results. When run via the VBA, it's decimals.
I feel I have two options here ...
i) use the code you provided (which I can't just cut and paste can I?), or
ii) change the time values in the datasource to text values.
In the VBA you so kindly provided, what can I change to transition to the directory style, from the form letters?
If I do choose to use the VBA you provided ... how do I integrate a filter for recipients. Right now, the code gives me all the records at once.