Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Mail merge help

  • Please log in to reply
2 replies to this topic

#1 rasik786


  • Members
  • 2 posts
  • Local time:07:32 PM

Posted 05 January 2017 - 01:10 AM

I have a mail merged document which is connected to an Excel sheet. The document has a problem with date, if the date is less than or equal to 12, the document will show it as month (I have made the format to dd mmm yyyy); for e.g, if the date is 9-Nov-16, it will show 11-Sep-16. But if the date is above 12, it will give the correct output. e.g, if date is 22-Nov-16, the out put will be 22-Nov-16. Please let me know the how to solve the issue.

BC AdBot (Login to Remove)


#2 MoxieMomma


  • Members
  • 471 posts
  • Local time:09:32 AM

Posted 05 January 2017 - 04:23 AM

It would help to know: what version of Excel, please?
Also, I have not tried any of these links, but perhaps they might be able to help:
Format a date the way you want - MS Excel

Date format problem in Mail Merge


Hope this helps,


Edited by MoxieMomma, 05 January 2017 - 04:25 AM.

#3 rasik786

  • Topic Starter

  • Members
  • 2 posts
  • Local time:07:32 PM

Posted 05 January 2017 - 06:51 AM

Microsoft Office professional plus 2010

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users