Boards
Geek squad assemble: MS Word mail merge fields
BOOBIES (.)(.)
Now I have your attention, please assist:
I have a mail merge file in Word. It consists of 1700 letters that were printed and sent on the 9th December. I need to re-print these letters with the 9th December date on them... BUT the date is a field set to today's date so whenever it opens up or prints its now the 21st Feb.
I've tried find and replace but that only works until you try to print or save...
WHAT I CAN DO?
I dunno nothing about
Change the date on your computer
work computer so i dont have admin rights
There must be some way of tricking word somehow
Create a header, drag the box down so it covers the date, type the date over the date, highlight the new old date and set it's background to white. No idea if this will work
its got to be a mass solution
I need to change all of the dates at once otherwise itll be a mega chore
a header would apply to every page, as long as they are one page letters it might work
maybe i could do a macro that pastes
A picture of the date over the top of the one on the letter?
what file type does word let you save it as? if it lets you re save it as a basic rich text file it might strip out the date field and convert it text, possibly
yeah maybe i could just do a paste special
And do text not formulas or spmething. Probably real simple
Maybe ask your secretary to sort it out?
That's what I'd do.
remove the field and just put the old date on as text....
1700 times (don't think you can get back to the template from the saved merged letters)
you should be able toas far as i remember, it's been a while since i've been without my secretary
if not i'm sure a find and replace will do it somehow or if that fails redo the merge
yeah this but theres 1700
Pages. I dont want to have to do menial work.
FRIDAY NIGHT!
(I just ate a cup of instaporridge at university, so I can hardly talk)
UPDATE - I DID IT
Just press CTRL SHIFT + F9 and this converts all fields to text.
UR WELCUM INIT
Yeah
Like I'm just gonna let this sink down the social board without recognition of my acheivements.
WOW Well done i-o
You've truly outdone yourself.
Sleep well tonight my son, for tomorrow the world will be yours