Hi there,



I use mail merge to fill a document with information. All is fine here and all the information is shown correctly in the word document. I filter the mail merge recipients so that only one is shown. I then use VBA Code to save this one page document and send it (with Outlook) as a PDF File. Some of the merge mail fields are used to fill the Body of the mail. One of the fields "MeldeschlussJVA" contains a date which is shown correctly in the document but incorrectly in the Email Body. Here's the field Code that supplies the date:

Format(ActiveDocument.MailMerge.DataSource.DataFie lds"MeldeschlussJVA").Value, "dd.MM.yyyy")

If the date shown in the word file is e.g. 06.07.2018 (July 6), it appears as 07.06.2018 (June 7) in the Mail Body. If the day is past the 13th of the month, the date appears correctly in the mail Body. Can anybody help me understand why this is happening and maybe have a solution to this problem. It's driving me crazy. I send a lot of email using this code and don't want to have to check each one manually to see if the date is correct. Thanks for all help.