Threads Replies Last Post 168 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>   Mail Merge. I have mail merge word doc, which links a different excel sheet dependant on the merge data. I need to refine this so that the link is based on the name of the sheet and the data in one of the merged fields. I.E .... where postcode in the merged doc = "BS28 1PP" insert the sheet named "BS28 1PP". I don't know if this can be written into an IF statement in the Link field. Please ....... an... 3 5/15/2007 1:45:30 PM word/excel mail merge My mail merge returns an monetary amount as 123000. instead of $123,00.00 How do i fix this ... 3 5/15/2007 5:10:03 AM Mailmerge in a macro I have a mail merge that works very nicely, but when I try to run it from a macro it errors out on the " .Destination = wdSendToNewDocument" line telling me the "requested object is not available". Any ideas? Thanks. Documents.Open FileName:="""Policy projection main.doc""", _ ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False, _ PasswordDocument:=""... 3 5/14/2007 5:48:52 PM Mail Merging a Selection from within an Excel Sheet Wondering if you can help, I'm kind of learning this as I go along so apologies if this is a really dumb question. I need to setup a mail merge that will use a specific selection from an Excel Sheet. For example everything under the column "University" that contains "LBS" needs to be merged. I can do this manually by either selecting the right records when I mail merge, or create a new... 6 5/14/2007 4:47:52 PM Price per day - Word 2000 Hello, I have to work out a 'pence per day' figure in a merge. I have come up with this formula - could someone tell me if it looks right please? { = ({ MERGEFIELD myamount }/30) * 100 \#"00p" } Thanks, Chris... 4 5/14/2007 4:36:46 PM Fill-In removes toolbars Hi all. I have a Word 2003 mail merge document that has a FILLIN field in it. The FILLIN works fine but the output document has no menu or toolbars at all. This means I can't print, save, format, etc. If I take out the FILLIN I get them. Any help? Rgds, Jaime ... 5 5/14/2007 8:29:25 AM Data Merge - Excel Records to Word Table Columns NOT Rows I'm either in over my head or I'm triying to accomplish the impossible. I want to merge partial fields from an Excel list into Word table cells. The standard direction of the record placement seems to be horizontally (within row cells and across columns.) I want the data to be placed vertically so I can place a <<next record>> at the top of each column and have the data flow ... 2 5/14/2007 6:54:45 AM Word Mail Merge Date Format I'm using Word 2002 SP2. Have had some real problems over the last week trying to get Word's mail merge to correctly (and consistently) interpret date values. I tried feeding in all sorts of date formats - this didn't work. I tried forcing Word to interpret my date as a string - this didn't work either. I was about to resort to injecting my date as three separate fields (a real sled... 6 5/14/2007 12:03:22 AM Currency Formatting - Word 2000 I need to format a currency field to be £0.00 if greater than £1 and 00p if less than £1 in the data source. The data source holds the data as 1.00 or ..50. I have created this query: {IF { MERGEFIELD } > 1 "£{MERGEFIELD\#,0.00 } "{ MERGEFIELD\#.00 }p" } The query does work but where there is just .50, it shows in the merge doc with a leading decimal point. My question is this - ... 9 5/13/2007 10:02:48 AM Anyway of putting mergefields INTO an Excel cell Hi all, I'm building a school report generator using an Excel doc as my data source and merging into a school report template in Word. The first worksheet in my spreadsheet contains the mailmerge field headings (firstname, subjectpronoun, object pronoun,english comment, maths comment etc). In the other worksheets in the workbook I generate the subject comments by checking or unchecking ... 2 5/13/2007 9:45:29 AM Show % in Table from Merge I am using Office 2007 and I am trying to use mailmerge to complete forms and instead of showing 85.7% it will show 0.857 6999999999459 (or something like that) Any help appreciated ... 3 5/13/2007 4:40:06 AM Avery postcards, blank second page I've created a mail merge for the my town office for sending out post cards using the Avery 4-cards/page. Everything was working fine for them until about a week ago. Now there is a 2nd (blank) page so when they print a second sheet is cycled through the printer. The second page has a paragraph marker but I can not delete it like a normal word doc that would eliminate the second page. I... 3 5/12/2007 5:08:26 PM Mail merge DIRECTORY issue with Excel as data source repeats doc p Hi, I'm using XP Pro sp2, Word 2003 & Excel 2003. Mail merge fields on single page with in large word doc. All looks good in preview merge, but when I complete merge, only one record from excel populates the page in Word with the merge fields, then the whole document repeats, adding the next single record from excel on the merge field page, again and again, repeating the whole document... 5 5/12/2007 4:36:19 PM Link excel table inside a condition Hi ! I use a mailmerge to produce 1, 2, or 3 graphics for each line of record. I have an excel file that contains 1 graphic per sheet. The name of the sheet is store inside {MERGEFIELD1}. After the merge, the path of each graphic must stay variable to be able to update the document for each graphic (ctrl-A + F9). When I do this, all link stay in text after after the merge (work fine) { ... 4 5/11/2007 6:46:30 PM What are header record delimiters? ... 4 5/11/2007 4:25:51 PM Merge Fields - 2007 It's probably several versions since I last used mail merge, so am rather rusty. When I set up my main document and insert merge fields into it, the merge fields aren't showing on the screen (although they work okay once I merge the data). I am used to seeing something like <name> to indicate a merge field. There must be a setting somewhere to change this, but I cannot find it... 4 5/11/2007 3:46:03 PM How can I use just the first character of a forename in a merge I need to set up a mailing from OUTLOOK contacts. I want to address the name as title, first character of forename, then surname i.e. Mr John Smith = Mr J Smith. I believe it is somewhere in field cods but cannot find anythig under HELP. Please assist Thanx... 4 5/11/2007 3:31:39 PM mail merge place cards I want to do a mail merge with place cards - the name on both sides of card with one of the names being upside down. As far as I know I can't do mail merge with text box (rotated text). ... 2 5/11/2007 12:00:59 PM Add 2 Currency Fields Together - Word 2000 Hello, I have 2 currency fields that need to be added together to create a 'total premium' field. Is this possible? Thanks, Chris ... 5 5/11/2007 10:59:00 AM Losing bold and underline with INCLUDETEXT I am so so so tired of trying to do something that should be so simple... My merge document has the following: Yada yada {INCLUDETEXT "c:\\morestuff.doc" \* MERGEFORMAT} Bla bla. My "c:\morestuff.doc" has the following: Hoodie hoodie [bold and underlined word] yuk yuk. When the merge is executed, result is: Yada yada Hoodie hoodie [word NO LONGER BOLD ... 6 5/11/2007 2:09:35 AM Merge data from Word to Excell Can you merge data from Word TO Excell? I've taken a scanned pdf file containing names and addresses and converted the text to word, it's in 3 columns, and I need to get it into a spreadsheet. It seems to me that it isn't going to work, but I thought I'd ask....it would be fantastic if it did, i've got a few thousand names to get into this Excell doc and I'd really rather not type it a... 2 5/10/2007 11:50:45 PM Mail Merge Recipient Problems Currently using Word 2002 I created my mail merge and data source. For some reason it keeps moving my current recipients that I have finished entering to the beginning of the recipient list. My recipient was up to 4000 so I created a new one it was working fine then started to do this. I have sorted the records so the appear how and where I want. But as soon as I go out of the file and t... 4 5/10/2007 10:40:32 PM Preserving Bold formating in Excel into the Word Merge Our datasource is an excel worksheet. We want the fomatting, including bold to come over into the Word document upon merging. We have not been able to find a way to preserve the bold from Excel into Word. Any ideas out there? We are in a hurry for this one...... 2 5/10/2007 6:44:42 PM Looking for example of merge field switch format zipcode in Word I m doing a mailmerge that includes addresses. I've read the Numeric Picture (\#) field switch, and it gave a lot of good ideas. But when I try, my zipcodes are often converted to dates. I also see that my leading 0 is dropped, and my 5+4 zips that have a dash are processed by subtracting. They are stored in my excel file in cells with Text format. Thanks, -cg... 3 5/10/2007 6:32:14 PM update all labels in a mail merge in 2007 2003 had a button for update all labels if I changed one. Does 2007 have the same button. I cant fins anything is this version. TJ... 3 5/10/2007 6:30:22 PM 168 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>