Hi, I would like to save a merged document to disk, without opening word. The merging works fine if I make word visible and let the user save the doc, but if I try to save from code without showing word, i get 'Opening this document will run the following SQL command'. The code I use is as...

Hi guys , I have got email id's in excel sheet ... i am trying to merge it with word 2007 and send email through outlook 2007 Now what happens lets say i have 2000 email id when i start sending/uploading mails in outlook after some email id , Emails stop uploading in outlook outbox and word...

Hello! I am trying to use Mail Merge to make customer lists for various contractors. I need to know how I can make the list on a single page for one contractor, then start a new page for the next contractor. For example: Say ABC company has 4 customers in the list, I want them all on the same...

I have to merge Access and Word files often. The Access file I’m using has a lot of fields and I quite often need to merge different documents using the same filters. I’m currently merging about 20 documents that will all need the same six filters—it takes quite a while to scroll down to...

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...

Hi Guys !!! Hope all of you are well & enjoying good sound health ... I've a serious problem & once again I'm on your board with believe that my issue will be solved I'm working in a organization where I'm supposed to send almost 100 letters to the clients whom have been charged different charges...

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...