Never mind... its working now (don't know why)



  • 1. Format from Excel not being shown in mail merge
    Hi, I have created a mail merge in Word from an Excel spreadsheet. The spreadsheet contains social security numbers that are stored as numbers 999999999 but formatted as 999-99-9999. When doing the mail merge Word will display the SSN as 999999999, not as 999-99-9999. How can I fix this? Thanks!! Helen
  • 2. IF statement with INCLUDETEXT
    Hello, I requested information from this user group before relative to the subject and achieved great results. However I have been unable to duplicate. the statement is below {IF {PART_TIME}>0 {INCLUDETEXT "FILENAME AND PATH"}} It doesn't actually show the field part_time it shows the value(0). Regardless of the value the document is inserted. I used ctrl+f9 to key braces but keyed in everything else except for the field part_time which is was input by insert a merge field Any assistance would be greatly appreciated.
  • 3. Printing L6163 labels
    I mail merge my addresses happily from excel to Word. I set up the document for Avery L7163 labels with no problems. I set up the fields with no problems. I merge it all with no problems. It looks fine on the screen. I do a trial printing them onto plain paper with no problems, but as soon as I print on to the actual label sheets, it all slips up, so is out of kilter with the label edges. It does this regardless of how I try to compensate for this in the layout. It is driving me insane. In desperation I then printed the labels with no problems at all using another computer with Word97 installed. Is this a known glitch? is there a remedy?
  • 4. MDE and Mail Merging w/ Word
    I am using Access 2000 and Windows XP. I am trying to make a mail merge in Word with an encrypted & secured (via FAQ steps) MDE. When I try to select the MDE as a data source though, instead of getting a list of queries and tables to select from, I get gibberish. It seems to be reading the MDE as straight text, instead of as a database. I think Word doesn't recognize the encrypted/secured format. Does anyone know how to mail merge to an MDE, or make Word recognize that the MDE is a database with tables and queries instead of a 'delimited' text file of garble? Thanks! Nick
  • 5. Mail Merge from data in excel to word document.
    I have an excel database which I am trying to merge into a letter. However where I have used a date and formatted the cells correctly for English date in excel they change to American in the word document. I have also used a funtion to show day of the week and this changes to a date. Can anyone help. Thanks.

Never mind... its working now (don't know why)

Postby U3V6YW5uZQ » Fri, 09 Nov 2007 03:08:02 GMT

Peter!  Never mind... I re-saved the Excel workbook as "V3" and for some 
reason, the dates are now appearing as they should be.  I have no idea why.

I am, of course, still open to any suggestions or changes to the Word and/or 
Excel documents (as you have the time/desire).


Re: Never mind... its working now (don't know why)

Postby Peter Jamieson » Fri, 09 Nov 2007 03:22:26 GMT

I've had a quick look, and I think the problem is caused by the fact that 
some of the fields are only present in the first data row. In this case, the 
Excel driver/provider may get a bit confused as to the data type. If you 
duplicate that data for the other rows instead of leaving it blank (if 
that's an option) I suspect things will go much better.

(FWIW What happens here is that when I first preview the data, I see a 
5-digit number instead of the date, as you do, but after that things seem 

Peter Jamieson

Re: Never mind... its working now (don't know why)

Postby U3V6YW5uZQ » Fri, 09 Nov 2007 04:38:06 GMT

hanks Peter... I had already copied the format down to row 250 (I'm still
trying to work out a way to programatically have Excel copy down to the next
row). I'm thinking the problem was the date format was originally "Custom"
-- and when Word encountered it, it didn't know what to do with it.

Regardless, it seems to be working fine now.

Thanks again!

"Peter Jamieson" wrote:

Similar Threads:

1.backspace disabled but i don't know why

I have somehow enabled a setting on Microsoft word 2002 which disables the use of backspace when you select text.  But I don know how to make it go back.  It quite hared to explain the problem and is easily described by an example:

Say you select a word which you want to delete you have various options of doing so, you can press the delete key (the most obvious), the backspace key or just type which replaces the selected word with whatever you type.  

These last two for some reason do not work in word anymore and it is extraordinarily annoying especially when you for get and there ends up being loads of words you thought you deleted left I your document.

I would love to find out how to fix this problem as it has happened on three of my computers.

2.When I open a word, it pops up and don't know why

When I open a word file, a window pops up saying "The command cannot be 
performed because a dialog box is open. Click OK, and then cloase dialog 
boxes to continue" I don't know why. 
Can you help me?

3.Cannot sucessfully download updates and don't know why

My spell check does not work on MS 2003.  I went to the MS site for updates 
and there were 3.  I clicked to download but it said it was unsuccessful but 
it did not say why. error 13 - Type mismatch (don't know why)


What worked six months ago seems to give a runtime error now.
Revisting a VBA routine as the project has come out of moth balls.

error 13 - type mismatch on the line:

Set bmrange = destdoc11.Bookmarks("section11").Range ' locate the bookmark

In the snippet of the whole routine,

If Dir(strAtt) = "" Then
MsgBox "File does not exist"
Set srcDoc = Wordapp.Documents.Open(strAtt) 'attachment sheet
End If

'open the letter
Set destdoc11 = Wordapp.Documents.Open(strInputFileName) 'letter

Set bmrange = destdoc11.Bookmarks("section11").Range ' locate the bookmark

'create new section - add a page past the bookmark

're-insert the bookmark as we have removed it by the section break
destdoc11.Bookmarks.Add "section11", bmrange
'copy the text and replace the bookmark
bmrange.FormattedText = srcDoc.Range.FormattedText
destdoc11.close (wdSaveChanges)

'close the Attachment sheet
srcDoc.close (wdDoNotSaveChanges)

I retraced my steps revisted posts from April and use of bookmarks on the 
FAQ word site and I can't see what could cause this glitch.
Corrupt VBA or the bookmarks in the original letter?

Any ideas appreciated.



what do i do

6. hey how do i open microsofft work it's key i don't know the 25 key

7. My IF statement doesn't work...anyone know why?

8. why don't work RUNADDON("DBU")

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 1 guest