Threads Replies Last Post 168 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Formatting Mergefiled Problems 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 a filed is blank. Example Mr Name-1 Name-2 43 Some Street City 0 0 0 postcode S... 5 12/22/2008 8:51:32 AM I am trying to print labels in word 03 using Microsoft Address Boo I cannot import or merge addresses from Microsoft Address Book to print labels in Word 2003. The result is unreadable.... 2 12/21/2008 7:29:07 AM Areas in Mailings field not highlighted 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. ... 2 12/20/2008 8:17:30 AM Add Signature Tiff doc to 50 Word docs in same place I have 50 word documents that I want to add the same signature to. Can this be done via Mail Merge? How? -- Janet A.... 10 12/20/2008 4:16:00 AM How/where can I get a Christmas midi to insert into a document? ... 1 12/19/2008 6:35:02 PM How do I format Mail Merge doc to pick up currency format from Exc 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 help is appreciated. Thanks, Sherry... 3 12/19/2008 4:46:00 PM How do I add recipients to a mailmerge label list? 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 add new names and addresses? There is no button on the Mailmerge toolbar to ADD recipients. ... 8 12/19/2008 2:02:47 PM mail merge cut off or truncating 255 word limit 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 open" exit microsoft word restart microsoft word connect your merge document to your ... 2 12/19/2008 8:44:40 AM mail merge shows numbers for dates 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 changes to a pre-set format (without even showing it to you). so for example, for 12/14/2008-... 1 12/19/2008 1:18:03 AM Mail merge problem with Word 2007 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 doing it manually and using the 'wizard' but have failed miserably - any thoughts please as to... 10 12/18/2008 8:41:02 PM Merging Word with Excel - using multiple rows within a letter 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 John Brown Corvette John Brown Chevette Is there an easy way o... 3 12/18/2008 7:47:01 PM Formating merge labels I am using Word 2003 I created a Pendaflex label merge in Word using an Access Query as the data source. On the label, I am using 2 fields; CoName and Acct#. Ex: «CoName» «Acct» The Coname prints to the left on line 1 and the Acct# prints to the right on line 2. I did this wit... 4 12/18/2008 7:40:32 PM Mail merge fields in a text box Hi Is there a way to create mail merge fields in a text box? I have custom-made letterhead where a graphic covers the whole sheet and the actual space for letter body is confined in a text box. If impossible, any suggestions to get around the situation? -- Maki @ Canberra.AU... 5 12/18/2008 6:39:01 PM schdmapi.dll missing in mail merge feature; detect & repair not wo Hello, I need some help please. I am trying to run a mail merge in Office 2003 Professional and when I click on data source and select Outlook as my source, I get an error message stating that I am missing schdmapi.dll. I tried detect & repair and this did not replace the file. Then I found a download of it, downloaded it, but did not know where to put it on my PC. Does anyone hav... 7 12/18/2008 6:54:23 AM Editing existing mailing label doc How do I edit entries in an existing mail merge mailing label document? I can select "edit recipient list" but then Word will not let me edit once I select the table to use. These are my Christmas card labels and every year I have some problem or another with this. I'd like to get this right once and for all! Thanks. -- Barb... 4 12/18/2008 6:47:51 AM Deleting blank lines in mail merge doc Hi, I have a mail merge document of about six pages whose data source is another word doc. However, not all the merge fields contain data at any given time. Sometimes I have two fields on page one with data and one files on page six with data. When I merge this info, I have five pages blank in between. How can I automatically delete these blank lines each i do the merge? Thanks in... 12 12/17/2008 9:38:21 PM Word 2007 Mail Merge - maximum amount of emails to send to? Looking for Help with Mail merge through Word 2007. I downloaded a csv from our database and used mail merge wizard through all the steps. I tested with 5 and then 10 emails and they all sent perfectly. The trouble came when I downloaded a csv with 20k emails/records. I tested sending 1-1000 records and it appeared to send fine. Did that for all the rest of the emails. The Problem c... 1 12/17/2008 9:36:10 PM Ignore blank address fields How to I get Word mail merge to ignore blank address fields. In other words, If address field 2 is blank, I don't want to priht a blank line... 10 12/17/2008 8:52:13 PM Excel to Word Mail merge I created spreadsheet and merge to word went fine. I added addresses to spreadsheet and saved in XL but the new data wont merge over. I cannot see new data under Review Recepeints. ... 2 12/17/2008 8:19:47 PM Mail Merge using INCLUDETEXT Following on from a previous post in Word Formatting (thanks to macropod for the help), I am using a program which essentially works using the same principles as a mail merge (enter a database, select a record, call a MS Word template, populate keywords). I have a source document with calculations which would be used in many templates, and will need to be updated and maintained, so that... 4 12/17/2008 7:35:56 PM Why do zip codes w/ leading zeros disappear when doing mail merge I use excel which contains zipcodes that begin with zero. When I merge the spreadsheet for letters and labels, the zeros disappear (I get a four diget zipcode instead of five). I formated the column as a zip code, but it still doesn't work.... 2 12/17/2008 7:18:57 PM Word 2007 Mail merge with .xls data source will only send 25 records at a time. After 25, Word hangs.... 2 12/17/2008 7:07:01 PM unwanted space in front of first word When I create labels through a merge it always puts a space on the first line of the address in front of the first word. How do I stop this?... 2 12/17/2008 3:51:08 PM Merge image field not displaying I am trying to use images in a word merge from Excel, without any success. In the original document I have three fields I have made to try and diagnose the problem: 1. {MERGEFIELD Flag} 2. {INCLUDEPICTURE "E:\\{MERGEFIELD Flag}" } 3. {INCLUDEPICTURE "E:\\{MERGEFIELD "Flag"}" } But in the new merged document, after I have prssed Ctrl-A and F9 to update, I still get 1. ae.jpg - whic... 3 12/17/2008 10:50:16 AM merge more than one line I am trying to merge from excel a list of invoices to each customer. I have come up with a formula but it is not working, and it prints on the letter instead of the data. What am I doing wrong. ORDER PO INVOICE DATE amount 01469 4500263177 255446 8/21/2007 0 {IF {MERGESEQ} = “1” “{MERGEFIELD CustomerNum}” “”} {SET Place 1 {MERGEFIELD CustomerNum}} ... 2 12/16/2008 11:41:44 PM 168 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>