I am trying to run a MailMerge from Word using an Excel Spreadsheet, but every time I try, I get an error in Word which becomes unusable. It stops working, but I have to remove it using Task Manager. If I click on View Problem Details when I get the error, it says the error is in the EXCEL32.CNV...

I am trying to set something up in Word to automatically update titles. Name Title Phone Name would be a drop down, and based on the selection, title and phone would update appropriatly to the name selected. I can not seem to figure this one out. I am not well versed in VB.

Hi all, I'd like to know if you can, and if so how to, mail merge into text boxes for label sheets with multiple labels on a sheet. I am making target stickers for my students, and the I cannot find a way for the layout of the sticker to work without using textboxes. Top left label is what it...

hi this is located in SHEET1 of the Workbook: No.............................HEADER-A.........................................................HEADER-B...................................... 1..........cell with garbeld text (over 1000 characters).....................cell with garbeld text (over...

I'm trying to perform the following calculation in Word 2007 mailmerge, using a txt file (with line return record delimiters and vertical bar | field delimiters) as my data source but I keep getting a syntax error if any of the fields have null values: R1 + C1 + M1 I can use IF statements to test...

Hi All, I've run out of patience on a project i'm working on. I need to mail merge some info onto some cards which have fields in pre-detrmined places. so far i've managed to take an image of the layout and set it as the background and also set out a custom label. I assume I need to use tables...

We have a mail merge document set up to print separate documents in the merge data. I have read a lot about how the \* MERGEFORMAT doesn't really do anything very good and we have that in each field. Out of about 15 forms there are 4 that have messed up formating and will not print correctly. I...

I am using Word 2000, and trying to mailmerge a document that contains a calculated field (=SUM(RIGHT)) - this field always shows up in my merged document as $000.00, and never the calculated value, though I can successfully select records based on that value. For example, I want to select the...

Using Word 2003. Using Excel as my data source. In Excel the "Quantity" field is formatted as "text" because it may have a value of 23 or 1 bag. When I do the Word merge, the fields that have any alphabetic characters in them display a 0. What is going on? Thanks for your help! Marie

I am making a service order sheet with all the contact info being pulled from outlook. I have prices for external cleaning and internal cleaning on the same price that i want to be put into the form { mergefield Initial_outside } / { mergefield Initail_IO } easy enough however If there is no...

Hi. I'm not sure if what I want to accomplish can be done in Word at all, I use Word 2007. What I want is two tables on one page, each table would have the same 2x4 layout so 8 cells per table. I want each cell to contain certain information from source data file but different for different table....

Hey guys, I wrote a macro that auto-updates all fields in a word document upon opening the document. I realized that this macro is local to my computer, so other people who open the file are not having their fields auto-update. Is there a way to attach a macro to a word document so anyone who...

When I do a Mail Merge, the address block gives me double spaces. How do I get a single space? I have tried Help but see nothing regarding this!

What if your word doesnt have dot matrix? I went to label options seeking the dot matrix so I could create Zebra roll labels and there isn't one. Is there anything else I can use. We use office pro 03 version

Hello all whom may read this thread. So I've been tasked by my superior to make most of our standard forms tamper proof after some numpty decided that they could alter some important documents without approval. This process was going swimmingly until I came across a document that contained Mail...

When laying out format on labels using MailMerge, Word automatically double spaces the lines. The label only has room for single space addresses. How do I single space the lines on a label?

problem solved.

I was hoping that someone might be able to let me know what trick is to merge an email list to an HTML format? I have absolutely no problem if I wished to send the merge file electronically using plain text as the Mail format but if I attempt to send the document as HTML it does nothing when I...

Hi Team, Could some one help me with the mail merge for the unique items in one email based on the unique email Ids. I have the excel sheet which is having the data also the excel data on document format. The word document on which the mail merge should come below the paragraph is also...

Hi to all. First off all i want to apologize in advance for my bad English, there are not my native language. so i have a dvd rental store and i want to print labels for every movie that i rent. i have created an Excel with all the data that i want to be on the labels and i imported them in the...