jaedis.blogg.se

1. #HOW TO GO TO NEXT RECORD IN MAIL MERGE IN WORD FOR MAC UPDATE#
2. #HOW TO GO TO NEXT RECORD IN MAIL MERGE IN WORD FOR MAC CODE#

where C2 is the original date-time field. To create a time field from a data field in Excel, please add an empty column and use the code: It seems to be a bug in Word 2007 and later. Please note that you have to convert date-time fields to time fields first in Excel if you want to use the Word formatting options for times.

Microsoft Support: Insert and format field codes in Word Microsoft Support: Insert and format field codes in Word - Date-Time format switchĮxample "dd-MMM-yy" to see the date in the format "dd/MM/yyyy" to see the date in the format "dd MMMM yyyy" to see the date in the format "28 February "dddd, dd MMMM yyyy" to see the date in the format "Sunday, 28 February "HH:mm" to see the time in the format "HH:mm:ss" to see the time in the format "h:mm AM\PM" to see the time in the format "1:45 "h:mm:ss AM\PM" to see the time in the format "1:45:30 PM" The date-time field codes are explained here: Microsoft Support: Insert and format field codes in Word - Numeric format switch The available switches are described here: \* Lower This switch changes all letters to lower case. \* Upper This switch capitalizes all letters. \* FirstCap This switch capitalizes the first letter of the first word. \* Caps This switch capitalizes the first letter of each word. Microsoft Support: Insert and format field codes in Word - Format switch The codes for text fields (alphanumeric fields) can be found here:

#HOW TO GO TO NEXT RECORD IN MAIL MERGE IN WORD FOR MAC CODE#

If you are formatting text fields, start your code with \*, for numeric fields start with \# and for date-time fields start with Formatting There are 3 different methods to format text.

#HOW TO GO TO NEXT RECORD IN MAIL MERGE IN WORD FOR MAC UPDATE#

Update the field by pressing F9 in Windows (Use Fn + F9 in OSX).Īlternatively you can also use ALT + F9 (Fn + Option + F9 in OSX) to toggle all fields between "field view" and "mail merge preview".Click with the mouse button on the field you would like to edit and add the formatting instructions (see below) at the end of the field (but before the closing curly brackets"}").

You can update the fields that are used to merge the text and define the formatting in MS Word.