Good morning I am having trouble merging from excel to word. Some of the text from excel when merged to word is missing. It recognises the correct column to find the data but does not pick it all up. i.e. It only shows some of the text that it is picking up. It is cutting my paragraphs in half. Is...

I am creating a form letter in Word, with an Excel file as the source. I am able to merge the file fine, except there is once cell that is not in the Merge Data Range, that I want in each document. How do you insert a single cell from an Excel file into a word document? NOTE: The cell I want to...

I cannot see a way to utilize the Category in an Outlook contact record to define a subset of my databsae for a mailmerge. Am I missing something? I can see how to manually select records from the database. It seems that there must be a way to do this, but I can't seem to figure it out!

Why dont I have an option to merge to email in the mail merge wizard? It only gives me the option to print or edit individual letters.

This may not be the correct forum, but I'll try...Is it possible to write a macro that will replace all occurances of a text string with an available field from a MailMerge source (specifically Access97)? I have a number of letter templates that change frequently, and I would like to automate this...

When I try to merge Excel data onto labels, on screen each label says next record, but no data. The data looks good when I click OK, but does not transfer. Thanks for any advice!

How do I create a picture directory in Word XP for a church...the mail merge already works for the data, we just cant get the picture lined up with the right contact. HELP!

In No matter how I format Zip code on Excel Source Document, when merged, zip codes beginning with "zero" or a Canadian Zip Code appear as the number "zero". Also, after saving merged document as .doc when I reopen it, I get the message, "Opening this document will run SQL command". Is there a way...

The Label Options in Word doesn't include Avery Label 5630, does anyone know if this can be added or downloaded from Microsoft?

Hello, I'm developing a word document for use with merge data, and one of the requirements of the document is to conditionally display a paragraph based on the value of a MergeField. I've considered using a sequence of {IF ... } fields, but that is neither elegant nor does it maintain proper...

I'm trying to merge graphics from an access database to a word formletter and I'm not getting any where. I currently have office 2000 and I've been trying to find out if you can do it in word 2003 or if you have to do the work-around in that version also. I haven't been able to get the...

Why does Microsoft feel that it is necessary with each new release to take something that works well and is easy to use, and screw it up? I have spent the last HOUR trying to take a data file (from an older version of Word) and create a simple checklist. It would have taken 2 minutes in the 98...

How do I format a merged numeric field from excel to contain only 2 decimals. The excel document has only 2 decimals, but once it merges to word, the field has 9 decimals. Thanks for the help.

Word 2000 - Creating a mail merge with 832 records. Some records have two address lines and some only have one. My records document has an "add_1" field and and "add_2" field. When there are two lines of address, I want them both to print. When there is only one, I want it NOT to leave a...

When I open Word 2003 I get a box that says 'The Command cannot be performed because a dialog box is open. Click OK, and then close open dialog boxes to continue'. Click OK and Word loads and performs normally. Not too much of a problem, but a pain in the butt. Anyone come across this and...

Background: I used to have no problems merging a database of 2400 names & addresses created on MS Xcel (old version) into a MS Word doc, and then printing out around 79 pages of labels. I was using WIndows 98. recently I upgrated my systems to Windows XP, and Office XP. Now, when I merge the...

Why does Word sometimes open another instance of Access when doing a mail merge? I have forms in Access with hyperlinks to Word merge documents which are based on queries from the form info. They were working flawlessly. Now, Word is opening another instance of access and the queries are not...

I have bought some Avery J8160 labels. I used Tools Envelopes & Labels in Microsoft Word 2000 to create a new document whole page of one address. I set it to use that particular Avery label (J8160) and A4 is selected in the Print Setup settings. Unfortunately the printed addresses do not match...

I have a co-worker having an issue with merging excel data into word and querying the data for specific information (both 2003 versions). When she does this, the first record is always the first line of data (even though the query should be excluding this line). It then skips the record...