You need to sign in to do that
Don't have an account?
DukeofTelluride
Mail Merge How to include automatically TODAY's date
Hi,
Can anybody help me get the formula for putting the date at the top of mail merge letters automatically.
i.e.
November 2nd 2007
Tom Smith
Attorney
Anywhere Street
I was given this formulat which is not working:
{ DATE \ @ ‘’ dd MMMM yyyy ‘’ \ * MERGEFORMAT }
thanks
Can anybody help me get the formula for putting the date at the top of mail merge letters automatically.
i.e.
November 2nd 2007
Tom Smith
Attorney
Anywhere Street
I was given this formulat which is not working:
{ DATE \ @ ‘’ dd MMMM yyyy ‘’ \ * MERGEFORMAT }
thanks
Also If you want the date written out like: 'October 30,2007' then you can use a formula similar to the one below:
CASE(
MONTH( CloseDate ) ,
1, "January"&" "& TEXT(DAY(CloseDate))&" "&TEXT(YEAR(CloseDate )),
2,"February"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
3,"March"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
4, "April"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
5, "May"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
6, "June"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
7,"July"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
8, "August"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate)) ,
9,"September"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate)) ,
10, "October"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
11,"November"&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
12,"December "&" "& TEXT(DAY(CloseDate ))&", "&TEXT(YEAR(CloseDate )),
"Invalid Date")
Heros,
Thank you
Sam
- Tanner Shamrock