MIS Systems Thread, Formatting Data Fields in Technical; My Head Teacher wants the date on an exclusion letter to have dates formatted as - Thursday, 18th December 2008 ...
18th December 2008, 09:15 AM #1
- Rep Power
Formatting Data Fields
My Head Teacher wants the date on an exclusion letter to have dates formatted as - Thursday, 18th December 2008 - as opposed to - 17 Dec 08 - as it appears at the moment. I have tried adding a switch to the <Start Date> merge field and have had some effect but as yet have not got it exactly as I want it.
Cheers and Merry Christmas
3rd January 2009, 03:38 PM #2
- Rep Power
Sims won't have a way of altering this, its not particularly good at dealing with mail merge type senarios at a complex level. Hence I suggest one of two solutions:
1) In the rtf tempate see whether there are any options to fiddle about with field options, particularly field 'switches'. you will have to look on the net to give what you want. don't know whether this will yeild any results, but worth a go.
2) extract the data into a csv and mail merge from there. only problem will be is if you want to deal with a one-to-many relationship which sounds like you'd want to. the only way round this is to use the csv as a table in an access database and create a report from here.
sounds like you might have to offer another solution for an easy life!
By garethedmondson in forum Office Software
Last Post: 11th December 2008, 03:22 PM
Last Post: 3rd October 2008, 11:36 AM
By duncane in forum MIS Systems
Last Post: 21st September 2008, 08:07 AM
By cjohnsonuk in forum MIS Systems
Last Post: 20th March 2008, 01:42 PM
By randle in forum Windows
Last Post: 25th October 2007, 01:20 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)