Mail merge times; How not to show seconds please?

  • Thread starter Thread starter gill.webster
  • Start date Start date
G

gill.webster

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.
 
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" }
 
Back
Top