Hi, I am merging data from excel into a word document. I am getting data in word that is showing "12:00AM", however, there is data in the excel sheet and it is NOT a date and it is not blank - it is part of an address line, such as "Deliver to Front Desk" or any kinds of words, but definately...

I've reviewed and followed the posts suggestions on this issue but still only the first and last rows of labels to display records. I'm using Word 2003. I created a clean spread sheet of only 17 rows . There are no long addresses. When I complete Select Your Data Source the first label is blank...

I am attempting to email clients that have mulitiple patients (animals). Instead of sending each client numerous emails I would like to combine the patients into one email. Is there a way to combine the names that show up in different rows into one row?

Hi I have a mail merge letter to send to potential clients. Some of the data in one merge field (Contact Name) is 'No Contact'. I want to set a rule in the mail merge template that says when the data 'No Contact' is merged it is replaced with 'The Manager'. Is there a way of doing this?

I have a mail merge document that works fine except a couple of the field are a percentage field , in excel i have formated it to 2 decimal points but wen it merges to work, it show the whole number which is about 15 digits any idea how to make it just the tow. is ok in excel but not in word

Hello, I am pulling in a date from Excel and it is formatting as a number. I have searched and see the example of { Mergefield Birthday \@ "MM/dd/yy" } -- Thanks, Pat

I'm trying to use field codes, and distilled down to a test case with a formula embedded in the first IF expression: {IF {=AND(12,13)} = 1 "OK" "BAD"} Looks simple enough - but I can't get this to display 'OK' - even when I update the field. I did see it work - but now it's gone again. Seems...

I have 981 names that I am merging from Excel into MSWord to create labels for our mailing. Everything says it has merged but only the first 30 names on the list will print...does anyone know where the other 600+ names are? I can't find them and it is frustrating...thanks,

Hi, I want to display numeric numbers without spaces: e.g. 1) if Price 1000, e.g. 12.3, then it is displayed as "12.3" 2) if Price = 1000, e.g. 10003, it is displayed as "10,003" However, if I format is as : {Price \# ,##0.0} 1) will be displayed with spaces. e.g " 12.3"

Hi I have looked up and found lots of similar problems with this but I haven't found a specific answer. By the way, this is the first time this problem has happened to me and I have done dozens of merges so I don't know what's happened. Firstly, my merged data from Excel is inserting a 0 where...

I cannot import or merge addresses from Microsoft Address Book to print labels in Word 2003. The result is unreadable.

I am using Word 2007 and working on creating a Mail Merge. None of my buttons on Write & Insert field in Mailings is highlighted and I need to use them. I have the Student Office installed and the trial Office Professional.

I have 50 word documents that I want to add the same signature to. Can this be done via Mail Merge? How? -- Janet A.

Office 2007, Windows XP I have created a data base using Excel that contains several numbers that are formatted as currency. When I insert these fields into my Word document (letter), the currency formatting is not there. I'm very new to Word 2007 and can't figure out how to change this. All...

This should be very simple. I created address labels using Word mailmerge and finished the merge, printed the labels, everything's OK. Now I want to add new recipients to my existing .mdb file and re-merge. I can open the original document and edit the existing recipients, but how do I actually...

here is a good solution ms word 2003 (and probably works for other versions) for mail merges using an excel database (just an excel spreadsheet with your merge information) in microsoft word 2003, with any document open, go to tools, options click the general tab check "confirm conversion at...

do you have a mailmerge where 12/14/2008 in the spreadsheet is turning into 39800 in your word document? first, make sure that all of your spreadsheet cells are in general format (format, cells, choose the general format). then, do NOT use just the date or other info that excel automatically...

I am having a problem in getting a successful mail merge to print some labels usng Excel as a data source on a 3 column, 7 row sheet under Office 2007/Vista. When doing the merge, only the first row of labels gets completed. I have used the same Excel data under XP without problem. I have tried...

Hello, I'm trying to merge an excel document that has multiple rows for one area and I want to bring them into the one letter; i.e.: John Brown owns three cars. I want one letter for John, referencing the three cars. So the excell file would look like this: John Brown Camaro ...