Mail merge times; How not to show seconds please?

[[email protected]]

I have a spreadsheet being used for mail-merge to Word letters, which
includes times for appointments. In the s'sheet the formatting is for
hh:mm but on merging the seconds alsos show and this is not required.
I'd like to know the easiest way of merging to show only the hour &
minutes.

I'd rather not have to manually enter another column of "text"
formatted times if there is another way that nayone can help me with
please?

Thanks a lot.

[JE McGimpsey]

This should be done within Word. In the mail merge document, use a time
switch for your field. See Word Help "Field codes: Time field".

Your edited time field code should look something like

{ MERGEFIELD TimeField \@ "hh:mm" }




In article <[email protected]>,
[email protected] wrote:

> I have a spreadsheet being used for mail-merge to Word letters, which
> includes times for appointments. In the s'sheet the formatting is for
> hh:mm but on merging the seconds alsos show and this is not required.
> I'd like to know the easiest way of merging to show only the hour &
> minutes.
>
> I'd rather not have to manually enter another column of "text"
> formatted times if there is another way that nayone can help me with
> please?