need help understanding mailmerge code

macropod · #2 02-13-2013, 05:19 PM

Your OrgDate test doesn't say "If the date is null then use current date". What it says is "If the Invoice date is null then use date_stamp date, otherwise, use the Invoice date" - both as the basis for doing a date calculation.

Be that as is may, you're using entirely the wrong field code if all you want is the first day of the next month. For that the field code would be:

Code:

{QUOTE
{SET StartDate {IF{MERGEFIELD InvoiceDate}= "" {MERGEFIELD Date_Stamp \@ M/d/yyyy} {MERGEFIELD InvoiceDate \@ M/d/yyyy}}}
{SET Delay 1}
{SET m{=MOD({StartDate\@ MM}+Delay+11,12)+1}}
{SET y{=INT({StartDate\@ yyyy}+(Delay+{StartDate\@ M}-1)/12)}}
"{m}-1-{y}" \@ "M/d/yyyy"}

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	8	02-11-2013 04:40 AM
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	13	05-29-2012 02:04 PM
Mailmerge	dkub	Mail Merge	35	12-07-2011 11:35 PM
Help with mailmerge???	foxtrot1981	Mail Merge	0	12-03-2010 08:21 AM
Understanding .docx XML tags for better performance	RithanyaLaxmi	Word	1	03-08-2010 01:41 AM