Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2011, 06:28 AM
macropod's Avatar
macropod macropod is offline Mail merge will not format date field generated by Excel IF statement Windows 7 64bit Mail merge will not format date field generated by Excel IF statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi borntorun75,

I suspect the fault has something to do with the empty cell in F2. As a workaround, you could change the formatting in column F to 'dd-mmm-yyyy'. Alternatively, you might try changing the data connection method to DDE.



Also, FWIW, you could also replace the 'Date_Ending' IF test in your mailmerge main document with a mergefield coded as: {MERGEFIELD Date_Ending \@ "dd MMMM yyyy" \b "Item available until "}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Import field from Excel to Powerpoint xgravity23 Office 8 11-22-2012 02:08 PM
Mail merge will not format date field generated by Excel IF statement Use a mail merge Field as the final doc filename DaveBF Mail Merge 1 10-22-2011 10:16 PM
Mail merge will not format date field generated by Excel IF statement HTML Content in Mail Merge Field Ilmater Mail Merge 1 09-04-2011 02:47 AM
Mail merge will not format date field generated by Excel IF statement Mail merge erases field codes Medievalguy88 Mail Merge 1 08-11-2011 05:21 AM
Mail merge will not format date field generated by Excel IF statement Date not transfering to mail merge correctly tonywatsonmail Mail Merge 1 07-01-2011 05:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft