Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2018, 02:34 PM
macropod's Avatar
macropod macropod is offline Field for date that I run the mail merge; not Date nor CreateDate Windows 7 64bit Field for date that I run the mail merge; not Date nor CreateDate Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Did you read Note 1 in the link's Introduction?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 12-19-2018, 03:09 PM
GregL GregL is offline Field for date that I run the mail merge; not Date nor CreateDate Windows 7 64bit Field for date that I run the mail merge; not Date nor CreateDate Office 2010 32bit
Novice
Field for date that I run the mail merge; not Date nor CreateDate
 
Join Date: Jun 2011
Posts: 12
GregL is on a distinguished road
Default

Thanks, yes, I read that, so I knew not to type the curly braces in the Word doc. I also tried not typing them into the Field dialog.

I searched that tome on "wrap" and found something that got me a little further. Under "Basic Mailmerge Maths", #2, it says "press Ctrl-F9 to wrap another field around it, thus { «Price» }".

I tried putting in a Date field, selecting it, and pressing Ctrl+F9. It put the curly braces around it. Woo-hoo! However, I don't know where to go from there to wrap a Quote field around it. If I select it, right-click and try to edit it, the "Edit Field" choice is grayed out. If I select it and choose Insert tab > Text section > Quick Parts > Field, and select Quote, the quote field replaces the Date field.

So... after I've pressed Ctrl+F9 on a Date field so it look like this in the doc....

{ 12/19/2018 }

...where do I go from there to wrap it in a Quote field?


Update:

I tried doing it the other way around, starting with the Quote field and adding the Date field inside it. Here's what happened:

- I added a Quote field, with the text "abc" as a placeholder, and returned that to the doc.
- I selected the new Quote field and pressed Ctrl+F9, which added the curly braces around it. At this point it looked like this:

{ abc }

- I selected the abc text and chose Insert tab > Text section > Quick Parts > Field, and added a Date field, choosing one of the date formatting choices. Returning from the Field dialog to the doc it looked like this:

{ December 19, 2018 }

But when I do the merge, this results in nothing; a blank line.

What am I doing wrong?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
Adding text before a date merge field AND fomatting date as well NikkiR Mail Merge 1 08-06-2014 07:18 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
Field for date that I run the mail merge; not Date nor CreateDate Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Wrong date with CreateDate Blablub Word 0 02-18-2010 04:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 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