Formatting for merge fields



  • 1. Using Excel Functions in VBA Word
    Hi, I need to parse a directory path provided as input in order to make the directories included in the string. I'm looking for a string function in Word that could do this but haven't discovered one. I know I can do this in Excel using the find function. Can I use the Excel Find function in Word? I believe i've done this in the past but can't recall how. Failing that, does someone have another suggest in terms of the approach?
  • 2. scroll window to a range
    Hi, I need to scroll the windowpane where I'm working positioning the to left corner of the line where a given range begins at it top left corner. Aditionally, I would need to verify if the bottom of the last line in the same range is visible in the screen, and if not, to zoom the window pane until the whole range is visible. I was looking for the ActiveWindow.ActivePane properties but I couldn't find anything to handle this. Can anyone help me? Thanks in advance. Pablo Cardellino
  • 3. Unprotect Documents
    I have been inherited a Document (form) used to maintain the personal records of the employees. This document have restrict the user from modifying the page set up and alter the formating or any modification i.e delete a text etc.. I need to edit a section of the documents now. Can any one help me in this regard. The password is not known to me or anyone in the unit at present. Question is how to make this document unprotest so that I can modify/ thanks in advance

Formatting for merge fields

Postby Jason » Wed, 06 Aug 2003 06:43:35 GMT

Is there anyway to format specific merge fields so that 
they can have dashes, decimal points or dollar signs in 
appropriate places?  I have a user that merges a bunch of 
informtion into several merge fields and I want only 
certain fields to have dashes, certain fields to have 
dollar signs and decimal points and so on.  


Re: Formatting for merge fields

Postby Doug Robbins - Word MVP » Wed, 06 Aug 2003 13:45:11 GMT

Hi Jason,

See the following page of fellow MVP Graham Mayor's website

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Re: Formatting for merge fields

Postby Jason » Thu, 07 Aug 2003 05:00:39 GMT


Thanks.  This solves most of my dilemna, but I am still 
having problems with text inserted from the userform into 
bookmarked locations.  I am having problems getting a 
phone number entered like this: 2225551212, and getting it 
to appear in the document as 222-555-1212.

The following displays the code I have for it thus far.  
Right now it's generating extra numbers.

.Bookmarks("contactfax").Range.InsertBefore TextBox11
.Bookmarks("contactfax").Range = Format(TextBox11, "###-

I think I just have the format incorrect.  Any help here?


newsgroups for the
questions forwarded


Similar Threads:

1.How do I format a merge field to display the correct Time format

Program:  Office 2007
I have a merge document word/excel but in my excel sheet the cells are 
formatted to display the time as 00:00 AM but when I merge the document in 
Word, the time displays as 00:00:00 AM.

How can I fix this?

2.Formatting a Merge field from xls doc

I have a Word 03 document that is merging data from an Excel 03  spreadsheet, 
and even though the data is formatted as currency ($#,###.00) when it is 
inserted into the Word merge document it has no formatting.  Do I have to 
format the merge field in the Word document, and if so does anyone know how?  
This is being done using Word & Excel 07 BTW.

Thanks a lot,

3.Formatting a merged field

I have a merged field called <<TOTAL>> that shows 73
How do I format his this to show $73.00


4.How do I format mail merge fields?

I am using Excel & Word 2003. I have tried to format the merge fields in my 
document without success. For example, I want the date to read 1 December 
2007.  After I press Alt+F9, my 'date' field is as follows : { MERGEFIELD 
"Date1" } so I changed it to read { MERGEFIELD "Date1" \@ "d mmmm yyy"} - but 
when I hit Alt+F9 again it doesn't change the format. What am I doing wrong?

5.US date format in merge field

Hello, I am trying to sort out a problem for my sister, we live in the UK, 
and her regional settings are configured to display dates as British dates 
(dd/mm/yyyy). She is doing a mail merge from an Access table, the table has 
some dates in a date/time field (which display correctly in British date 
format). The mail merge all works correctly except that when they come into 
Word, the dates are switched to US date format (mm/dd/yyyy). Dates normally 
display correctly on her machine, and I can't see any way to change it in 
this mail-merge.

Any Ideas? Please? 

6. Formatting of merged fields for date and times doesn't work with E

7. Formatting Highlight Merge Fields shading

8. Formatting of merged fields for date and times doesn't work wi

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 32 guest