Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-15-2024, 06:47 AM
Andy.T Andy.T is offline New to fields, how do I re-use a DateCalc example in a mail merge? Windows 11 New to fields, how do I re-use a DateCalc example in a mail merge? Office 2021
Novice
New to fields, how do I re-use a DateCalc example in a mail merge?
 
Join Date: Jul 2024
Posts: 5
Andy.T is on a distinguished road
Default New to fields, how do I re-use a DateCalc example in a mail merge?

Hi there,



Sorry, I'm very new to all this, please bear with me.

I've inherited a mail merge document and I need to add a new field that displays the 1st of next month based on a value in my source data (a column called Date_First_Payment).

e.g. If Date_First_Payment = "10/07/2024 00:00" then I'd like to show "1st August 2024".

I've had a look at DateCalc V2 and it looks like there's a brilliant function there that I can tweak slightly to give me what I want, "Calculate the day & date of the nth day of next month".

However, I'm a bit lost as to how I'd actually get that function pointed to the datasource value of Date_First_Payment, rather than today's date.

I've tried removing the "Date" and then, in its place. inserting my Date_First_Payment mailmerge field, but I get...

1-!Syntax Error, ,-2024

I'm not sure if it's just the way I'm adding the field in that's wrong, or if the presence of the time "00:00" in my data value, is what is scuppering it?

Any pointers would be greatly appreciated.

Thanks a lot,

Andy
Reply With Quote
  #2  
Old 07-16-2024, 02:08 AM
Andy.T Andy.T is offline New to fields, how do I re-use a DateCalc example in a mail merge? Windows 11 New to fields, how do I re-use a DateCalc example in a mail merge? Office 2021
Novice
New to fields, how do I re-use a DateCalc example in a mail merge?
 
Join Date: Jul 2024
Posts: 5
Andy.T is on a distinguished road
Default

Hi,

I managed to sort this out myself.

In case it helps someone else clueless, I found I only needed to delete "DATE" (or "Date") and then literally just type "MERGEFIELD Date_first_payment" in its place.

I thought as I was changing it from the Word "DATE" value to a merge field that I would need to do Insert Merge Field (as you "always have to use the UI").

However on this occasion, as the structure I needed was already there, this was inserting extra brackets around the merge field which I didn't need.

Thanks,

Andy.T
Reply With Quote
  #3  
Old 07-16-2024, 10:12 AM
Charles Kenyon Charles Kenyon is offline New to fields, how do I re-use a DateCalc example in a mail merge? Windows 11 New to fields, how do I re-use a DateCalc example in a mail merge? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

For those finding this thread, look at Paul Edstein's:
These are pinned to the start of this forum. These are extensive and should be saved to your computer so you can reference them without Internet access!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
New to fields, how do I re-use a DateCalc example in a mail merge? Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge djrexy Mail Merge 1 05-20-2020 04:04 PM
New to fields, how do I re-use a DateCalc example in a mail merge? Mail Merge fields merge incorrectly and won't fix. marym Mail Merge 3 04-09-2016 05:17 AM
insert fields mail merge in vba tariqaleed2 Word VBA 6 08-21-2014 12:21 AM
New to fields, how do I re-use a DateCalc example in a mail merge? Mail Merge only produces 15 fields fm 22 Galceran Mail Merge 2 02-10-2013 05:47 PM
New to fields, how do I re-use a DateCalc example in a mail merge? Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM

Other Forums: Access Forums

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