Merged letter and made changes to merged letters. Final merged doc

Merged letter and made changes to merged letters. Final merged document has 
date in field code and atty wants to change it from Jan 5 to Jan 4. She does 
search and replace but the date automatically updates on print, even if we 
change that setting.
-- 
Serena
0
Utf
4/16/2010 2:09:01 PM
word.docmanagement 5542 articles. 2 followers. Follow

3 Replies
835 Views

Similar Articles

[PageSpeed] 26

-- 
Serena


"Serena K." wrote:

> Merged letter and made changes to merged letters. Final merged document has 
> date in field code and atty wants to change it from Jan 5 to Jan 4. She does 
> search and replace but the date automatically updates on print, even if we 
> change that setting.
> -- 
> Serena
0
Utf
4/16/2010 2:13:02 PM
That's the thing about Date fields they update to the PC's system date. 
You'll need to unlink them. The following macro will do that

Sub Macro1()
Dim oField As Field
For Each oField In ActiveDocument.Fields
    If oField.Type = wdFieldDate Then
        oField.Unlink
    End If
Next oField
End Sub

http://www.gmayor.com/installing_macro.htm

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


"Serena K." <Serena@community.nospam> wrote in message 
news:B186B387-C498-4A5B-B9A0-7DA2EC8F3047@microsoft.com...
> Merged letter and made changes to merged letters. Final merged document 
> has
> date in field code and atty wants to change it from Jan 5 to Jan 4. She 
> does
> search and replace but the date automatically updates on print, even if we
> change that setting.
> -- 
> Serena 


0
Graham
4/16/2010 2:21:50 PM
Hi Serena,

In your mailmerge main document, select the date field, press Ctrl-F9 to enclose it in a pair for field braces (eg { 01-05-2010}) 
and type 'QUOTE' inside the braces, so that you end up with {QUOTE 01-05-2010}. Then run your mailmerge. This will prevent the dates 
from updating in the future. It also means a Find/Replace on the dates will work.

-- 
Cheers
macropod
[Microsoft MVP - Word]


"Serena K." <Serena@community.nospam> wrote in message news:B186B387-C498-4A5B-B9A0-7DA2EC8F3047@microsoft.com...
> Merged letter and made changes to merged letters. Final merged document has
> date in field code and atty wants to change it from Jan 5 to Jan 4. She does
> search and replace but the date automatically updates on print, even if we
> change that setting.
> -- 
> Serena 

0
macropod
4/16/2010 10:11:12 PM
Reply:

Similar Artilces:

merging
Is it possible to create a document in publisher (mine is a certificate) and then merge the desired information from a select querry in access? Hi Tina (sttpreston@clyde.k12.oh.us), in the Microsoft� newsgroups you posted: || Is it possible to create a document in publisher (mine is || a certificate) and then merge the desired information from || a select querry in access? Yes, you can. Which version of Publisher and Windows are you using? -- Brian Kvalheim Microsoft Office Publisher MVP Official Publisher MVP Site: http://www.kvalheim.org This posting is provided "AS IS" wit...

Auto table name change in Access queries
Do anyone know how to disable automatic table name change in Accessqueries?Currently, I am testing a set of 30 queries in an Access database andneed to have these 30 queries run on different tables, for example,tblA, tblB, and tblC. I have all 30 queries built using tblA. Iwanted to test the data in tblB, so I renamed tblA to tblA_BK and tblBto tblA. However, when I ran the queries, some queries are referringto tblA but some are referring to tblA_BK. Why it that? How toprovent this from happening?Thank you in advanced for your help.- Grasshopper - That is done by Name AutoCorrect, which i...

changing budget period -how?
WE have set up a budget in Money 2002. But my paycheck gets deposited a few days before the 1st of each month. Thus, when I run the buget report for that month, it shows that I have no income yet for that month but plenty of expenses already. Is there any way to ge the budget period to change from the calendar month to a period starting on the date of my paycheck deposit and running until the day before the next deposit? No. "CLP" <anonymous@discussions.microsoft.com> wrote in message news:25c1701c46118$d169fcb0$a501280a@phx.gbl... > WE have set up a budget in Mo...

Merge same transaction
I've had transactions that I've placed in my register with detailed info in the memo area only to have the same exact transaction download with no info and unrecognized as the same transaction. Traditionally I've copied and pasted the info into the downloaded transaction and then deleted my transaction. This is a real PAIN... Is there a way to tell Money that these two separate transactions are the SAME transaction and then have it merge them? It works exactly as intended when Money recognizes the transaction that's already in the register and then merges them beautiful...

Merging 2 Companies into 1
Are there any guidelines or outline for what tables you need to look at to gather the various information you need in order to merge 2 companies together as well as issues to consider when undertaking such a project? It is a project and a half. I got approval from a major client yesterday to proceed with just this project. You literally need to look at all of them! I understand that MS Professional Services will do this project for you. In my case the client cannot be down and has too many 3rd party products for us to pass it off. When does your project need to be completed? -- Ri...

Can't find how to change Y-axis range to show new data in Excel Mac 12.2.4
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a simple bar chart that I created some years ago in a previous version of Excel. I add data each month and it shows miles I drive per month over the year, very helpful to keep track of distance and gas mileage. I've extended the Y-axis range downward a few times before, but can't find out how to do it this time. I always install the latest updates from Microsoft and now I'm running Excel 2008 for Mac version 12.2.4 (100205). My Y-axis range in this chart starts at 800, but I drove only 772 miles ...

Change color of the border..
There are some components as the combobox that doesn't give option to change the color of the border, there is some form of making it thank you ...

Word mail merge
After printing a document there exists a activity with subject "Word Mail Merge" to the contact with status completed. Is there a possibility to change the subject name or to make a link to the original Word document? R, Joop. I think that the subjct name is hardcoded. The issue of only adding this paltry information to the activity and not showing what document was sent is a problem many have asked about. Microsofts workaround to this glaring gap in functionality is to then add a copy of the word document to the record using notes. Totally unworkable if you have just mail merg...

How do I change the shadow color on a 3-D chart/Graph
I'm trying to align colours in a 3-D chart. But the shadow on the 3-D is staying one colour even when I change the surface colour. So when I have a green 3-D box on my chart and the next box is red - the shadow on the red box stays green. I would like it to be red. Can anyone help. I'm sure it's an easy one but it's frustrating me!! Hi Nina, You say "shadow" but it sounds like you are asking about the depth portion of a 3-D object? What version of Excel are you using - in 2003 and 2007 if you change the color of the individual data point (a single bar) ...

only one letter shows typing shortcut name
Windows XP pro SP3 This isn't really a big problem. I'm just curious about what is going on. Recently I notice that typing in a name (or changing a name) for desktop shortcut does this: The first three letters show up, then only one letter (the letter just typed) shows as the typing continues. The field expands as the name is typed but only one letter is visible as it is typed, until I am finished and hit return. Then the whole name shows up. Again, no big issue. Just curious. Any thoughts appreciated. Jack ...

mail merge/merging 2 address lists...
Is there a way to merge two of your address lists in Publisher 2002? I have two address lists in my data base folder and would like all the addresses merged into one as there are some addresses different in each and some the same. Thank you. Robin Hi Robin (vicary@kconline.com.NOSPAM), in the Microsoft� newsgroups you posted: || Is there a way to merge two of your address lists in Publisher 2002? || I have two address lists in my data base folder and would like all || the addresses merged into one as there are some addresses different || in each and some the same. No, you cannot. You nee...

merge and compare
We have two versions of the same work sheet from differnt dates. Some of the cells have been changed in the latest version and we need to compare which cells have had changes and selectively merge the two. Is there any hope??? jimired wrote: > We have two versions of the same work sheet from differnt dates. > > Some of the cells have been changed in the latest version and we need > to compare which cells have had changes and selectively merge the two. > > Is there any hope??? Hi have a look at http://www.cpearson.com/Zips/Compare.ZIP An add-in which compares two worksh...

Column headings in Excel showing up as numbers, not letters
I think I accidentally hit a wrong key at the wrong time - and all of a sudden, my column heading labels in Excel are showing as numbers (i.e. 1,2,3, etc.) instead of letters (i.e. A,B,C, etc.) - can anyone tell me how to recify this. Go to Tools>Options>General and uncheck the box marked R1C1 Reference Style. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dickster" <anonymous@discussions.microsoft.com> wrote in message news:c41701c3ed97$921eea10$a401280a@phx.gbl... > I...

I Need to change reference sheet for all cells on a form
Good afternoon, I am copying a spreadsheet to make summary sheet and I need to change which sheet the cells are referncing on my copy. Some of the cells refer to for example, =PRIOR YEAR!B3, some of the cells use a command to Round(PRIOR YEAR!B3/100), I would like to change all the references that currently refer to "PRIOR YEAR" sheet and make them "CURRENT YEAR" sheet, so my references would look like this =CURRENT YEAR!B3 and Round(CURRENT YEAR!B3/100). I am curious if a paste special, or shortcut exists that can do this quickly so I dont have to go in and manual...

Changing Requirement Levels when a Regarding entity is selected
Hi there, I was wondering if it is possible to change a field from a business recommended to a Business Required mode when a custom entity is selected on the Regarding lookup field. Lebo ...

How can I get bar codes w/ Excel & mail merge?
I want to send out a bulk mailing with large postcards. I want the addresses printed on the postcards via mail merge. I am using Excel, but don't see where or how to add the bar code to the address, which would save me a lot of money. Can you help? >-----Original Message----- >I want to send out a bulk mailing with large postcards. I want the addresses >printed on the postcards via mail merge. I am using Excel, but don't see >where or how to add the bar code to the address, which would save me a lot of >money. Can you help? >. > hi, I not entirely...

Merging worksheet into MS Word mail merge
I am merging a letter and an Excel worksheet. When I merge an Excel field that contains $ and commas separating the hundreds and thousands, the $ and the , do not show up in the merged letter. Any suggestions on how to solve this problem? -- Briggs Hi Instead of just referring to the cell e.g. A1 use =TEXT(A1,"[$$-409]#,##0.00") -- Regards Roger Govier "Briggs" <Briggs@discussions.microsoft.com> wrote in message news:2F326201-A50F-45E5-9767-4C189ACA5529@microsoft.com... > I am merging a letter and an Excel worksheet. When I merge an Exc...

Changing the user password without the use of SA or DYNSA accounts
Is there any way to save a user password in GP v10 without the use of the SA or DYNSA login? I would like to grant security to one user to do this. Currently the save button is greyed out unless they log in as SA or DYNSA. Thank you You can do this by granting that user sysadmin rights in SQL management Studio. In SMS, expand the Security folder, then logins, then find that user, right click the user, go to properties, click server roles and check the box for sysadmin. "Junior De Alba" wrote: > Is there any way to save a user password in GP v10 without the use of the S...

Error in Mail Merge when selecting Edit Individual Labels
We are noticing an interesting error when trying to perform a mail merge within CRM and Microsoft Word. We have created a view in contacts and we perform all the typical mail merge functionality using the Labels option. At the end, instead of printing the labels without any edits, we click on “Edit Individual labels” and we get the following error… C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE has encountered a problem and needs to close. We are sorry for the inconvenience. We are on CRM v4 Update Rollup 8 using Outlook 2007 and the CRM Outlook (Online only) client. Has an...

Shading A Line Using Accent, etc. Why Other Changes Also ?
Hello, Using Excel 2007 and W7. Have a simple spreadsheet where the first column is dates, and then the next three are blood pressure readings (systolic, diastolic, and rate). I thought it would be clearer if I shaded in the Rows that had PM readings. So, I went to Home\Cell Styles, and selected the 20% Accent 1 for shading. After selecting the line, it works just fine. But, each and every time I try it, it changes my font size and font type for the line. Seems to automatically revert to some default, or... ? Also, if I have a cell in the line Bolded, it eliminates the Bold. I though...

Help! Powershell changes text file sizes??
When I run a command with invoke-expression in Powershell, it creates a file almost twice as large as the same thing run from command prompt. Can anyone tell me what is going on here? If I run the following command from a command prompt, I get a 14K text file: dfsradmin rg list /attr:RgName,ObjState >> report.txt If I run the following command from a Powershell prompt, I get a 27K file: invoke-expression -command "dfsradmin rg list '/attr:RgName,ObjState' >> report.txt" Gary schrieb: > When I run a command with invoke-expression in Pow...

Pasting into merged cells #3
I want to copy information from an area that doesn't have merged cells to an area that has merged cells. When I do this I either get an error message or when I use the Paste values and number formats it only pastes every other entry. Is there another way to paste that I don't know of that will paste into the merged cells? -- Thanks, Nikki Hi best would be to get rid of merged cells. You could of course paste cell by cell "Nikki" wrote: > I want to copy information from an area that doesn't have merged cells to an > area that has merged cells. When I do ...

Sudden Change to Database Forms
We have a database that has been in use for a few years. Recently we upgraded our MS Office to 2003. Since that time on one of the desktops that uses the front end there was an event that has rendered the front end unusable. The user was entering data to a form when she suddenly found a screen that said something like "the computer will need to reboot". Unfortunately the person making observations was not careful in observing exactly what transpired, but since that time all of the fields that have lookups based on queries do not work. If you check the underlying queries in des...

Autofit Row & Merged Cells
Is this just me or is it a common problem: I have some text in a cell. The cell is merged along a row with the adjacent cells, I have put word wrap on. Now Autofit Row doesn't work and only shows the first line of text. Is there anything I can do, apart for manually adjust the row height? Regards Take a look at this macro by Jim Rech: http://google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05 If you need help getting started with macros, look at David McRitchie's Getting Started with Macros page: http://www.mvps.org/dmcritchie/excel/getstarted.htm In article...

Merged letter and made changes to merged letters. Final merged doc
Merged letter and made changes to merged letters. Final merged document has date in field code and atty wants to change it from Jan 5 to Jan 4. She does search and replace but the date automatically updates on print, even if we change that setting. -- Serena -- Serena "Serena K." wrote: > Merged letter and made changes to merged letters. Final merged document has > date in field code and atty wants to change it from Jan 5 to Jan 4. She does > search and replace but the date automatically updates on print, even if we > change that setting. >...