Today there was this small thing that took my time. A date field in excel was formatted correctly but when the field was used in the mailmerge with Word. The format in the excel was not being reflected in word.
So I used the following steps to correct this in Word.
Step 1. Right click on the field name
Step 2. Click on the ‘Toggle Field Codes’ option For eg., { MERGEFIELD “AFinish” }
Step 3. Edit the field to include \@ “dd-MM-yyyy” e.g. { MERGEFIELD “AFinish” \@ “dd-MM-yyyy” }
Step 4. Right click and click update field.
You can see the date format as 17-08-2008
Subscribe to:
Post Comments (Atom)
Deploy the Azure Machine Learning Model
In the previous post I have discussed how to create an Azure Machine Model. In this post I will be discussing how to Deploy this model. Pre...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
-
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
-
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
No comments:
Post a Comment