Mail Merge (2)

[traff1982]

Hi

I have a date in the spreadsheet which is showing as a standard British date (dd/mm/yyyy) but when it is merged into a letter it comes up as mm/dd/yyyy.

It should be the way it is shown on the spreadsheet but i'm not sure how to change it.

Any help would be appreciated.

Cheers

Marc

 

[Norie]

Marc

As was suggested in your other thread what you need is switches.

I don't use Word too much but I know that if you search help there's plenty of info on how to use switches.

 

[Macropod]

Hi traff1982,

In this case, you need to edit your mergefield code, adding a date switch to it, in the form of:

{MERGEFIELD "DateField" \@ "d-MMM-yyyy"}

or:

{MERGEFIELD "DateField" \@ "dd/MM/yyyy"}

or:

{MERGEFIELD "DateField" \@ "ddd, d MMMM yyyy"}

or:

{MERGEFIELD "DateField" \@ "dddd, d MMMM yy"}

etc.

Cheers