Guys, Does any one knows how to insert today’s date in Mail merge doc and also how can we attach a document/sheet to mail merge recipients?
From India, Pune
Acknowledge(0)
Amend(0)
70From India, Pune
Acknowledge(0)Amend(0)
Mayur, One thing yoy can do in the reference cell of excel you may type =today() and then use the same reference in mail merge hope this will work.
From United States
Acknowledge(0)Amend(0)
From United States
Acknowledge(0)Amend(0)
Hi mayur, please right click on the reference cell and select date in formatting. The dates will appear in desired format...i think this will help... Regards divya
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
but when we mail merge the date column with doc file then mm-dd-yy format appears, can we change this format in dd-mm-yy format in word mail merge doc?
From India, Kota
Acknowledge(0)Amend(0)
From India, Kota
Acknowledge(0)Amend(0)
Dear Mayur Shinde,
While creating the Excel data, change the date field to text format so it will appear as it is in the mail merge. Right-click the date cell, and go to format, then select text in the category.
Regards,
Sudharshanan
From India, Madras
Acknowledge(0)Amend(0)
While creating the Excel data, change the date field to text format so it will appear as it is in the mail merge. Right-click the date cell, and go to format, then select text in the category.
Regards,
Sudharshanan
From India, Madras
Acknowledge(0)Amend(0)
Dear Mayur,
You can also use Field to create your own date formats and insert them in the document. In Word 2007, the option is available under Insert -> Quick Parts -> Field -> Date. In the Date Formats text box, type dd-mm-yy.
Regards, Antony.
From India, Madras
Acknowledge(0)Amend(0)
You can also use Field to create your own date formats and insert them in the document. In Word 2007, the option is available under Insert -> Quick Parts -> Field -> Date. In the Date Formats text box, type dd-mm-yy.
Regards, Antony.
From India, Madras
Acknowledge(0)Amend(0)
Guys, None of the above works as desired. The format in word doc appears as mm/dd/yy, and what I expect is MMMM, DD, YYYY.
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Dear Mayur, I have tested your date format string (MMMM, DD, YYYY) and its working fine using Field code option. Check once again. Regards, Antony.
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Antony, As per your instruction, I can insert MMMM,DD, YYYY in word doc, but i cannot Mail merge that field from a Excel sheet. its comes in a different format..
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Sorry, now I only understood your exact problem. Please try the following solution:
Right-click the date field in Word and select Edit Field Option. Then, click the Field code button located at the bottom left of the dialog box. It may show a field code string in a box like "MERGEFIELD Date."
In my Excel sheet, I used the field name "Date." In your system, it may be different. Insert the text below after Date: @ "MMMM, DD, YYYY"
The final field should be "MERGEFIELD Date @ "MMMM, DD, YYYY"
Now, click the OK button and check the output.
From India, Madras
Acknowledge(0)Amend(0)
Right-click the date field in Word and select Edit Field Option. Then, click the Field code button located at the bottom left of the dialog box. It may show a field code string in a box like "MERGEFIELD Date."
In my Excel sheet, I used the field name "Date." In your system, it may be different. Insert the text below after Date: @ "MMMM, DD, YYYY"
The final field should be "MERGEFIELD Date @ "MMMM, DD, YYYY"
Now, click the OK button and check the output.
From India, Madras
Acknowledge(0)Amend(0)
Dear Mayur,
Have you found the answer to your second question? How can we attach a document/sheet to mail merge recipients? We can do it programmatically. If you need any assistance, please contact me.
Best Regards,
Antony.
From India, Madras
Acknowledge(0)Amend(0)
Have you found the answer to your second question? How can we attach a document/sheet to mail merge recipients? We can do it programmatically. If you need any assistance, please contact me.
Best Regards,
Antony.
From India, Madras
Acknowledge(0)Amend(0)
Please do this on your PC as shown:
Go to Control Panel > Date, Time & Language Option > Regional and Language Option > Customize > select Date Tab and change the DD-MM-YY option in Short date format.
Hope this will be useful.
Eshwar
MIS & ERP
From India, Mumbai
Acknowledge(0)Amend(0)
Go to Control Panel > Date, Time & Language Option > Regional and Language Option > Customize > select Date Tab and change the DD-MM-YY option in Short date format.
Hope this will be useful.
Eshwar
MIS & ERP
From India, Mumbai
Acknowledge(0)Amend(0)
Go to word document / click insert / click date & time / select the date format you need. Or else, in the excel sheet you need type the full date by adding ' in front of the date. Eg - '13 June 2012
From Sri Lanka, Colombo
Acknowledge(0)Amend(0)
From Sri Lanka, Colombo
Acknowledge(0)Amend(0)
The below step would insert today's date in the required format:
1. Insert any field from the base data field on the Mail Merge Template.
2. Right-click the field and select Edit Field.
3. Under Categories, select the Date & Time Option.
4. In the Date Time Text Box, enter dd-MM-yy.
From India, Mumbai
Acknowledge(0)Amend(0)
1. Insert any field from the base data field on the Mail Merge Template.
2. Right-click the field and select Edit Field.
3. Under Categories, select the Date & Time Option.
4. In the Date Time Text Box, enter dd-MM-yy.
From India, Mumbai
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
NO TO WORD IN EXCEL FORMAT.xls
New Microsoft Word Document.doc