Threads Replies Last Post 168 Pages: <<  9  10  11  12  13  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  >>   Excel data into an Office calendar format? I am working on our district calendar and we are trying to combine multiple use calendars using the same database. I have always created a printed calendar with lovely pictures for parents' use. Now that I have all this calendar data in an Excel spreadsheet needed for the other uses, I am troubled trying to come up with a way to use this data (without retyping it all) in a format that ... 2 6/7/2007 12:11:20 PM How do you merge a document with several records on one page? Using Microsoft Office Word 2003 and Excel 2003, I am trying to create labels in Word with only one field, but several records from Excel. When I merge, I am only given the option to have one record per page. Which won't work with several labels on each page. I have done this previously, but don't remember how, but know it can be done. I beleive I used a "next record" command, but ca... 2 6/7/2007 9:25:17 AM Truncating in Mail Merge Hi All, I'd like to print just the last 4 numbers of an account number in a mail merge letter (front fill the rest with asterisks). It seems like it should be just as simple as the RIGHT function in Excel but by necessity my source document has be a CSV text document so the function has to take place in Word. Is this possible? Thanks so much! Laurel ... 9 6/7/2007 9:18:16 AM word could not finish merging Hello, I'm merging about 600 records and it stops merging everytime at record 446. I've looked through the document and there doesn't seem to be anything different about it. I then went to my data source and deleted record 1-445 and then try to merge the remainder but it won't even look at the data source. Help! :) THANKS!!... 2 6/7/2007 9:15:33 AM mail merge data to flow up and down rather than left to right When merging data into labels, how can i make the data merge from excell to word and have it print up and down rather than left to right?... 2 6/7/2007 9:14:50 AM Word Default MailMerge datasource I am initiating a mail merge from access with code similar to the following: http://support.microsoft.com/kb/209976 The macro works, but now whenever I open Word to a blank document, or any unrelated non-mailmerge document, I get the message "Opening this document will run the following SQL command: Select * from [table from macro]. It occurs when I have no applications open. I think som... 2 6/7/2007 9:03:16 AM mail merge missing records Hi, I decided to post my question again. Hopefully more clear on what's going on. I have a data document and I see all of my records. I go to merge it and if I select edit data there is only one record showing up. I am doing the same process I did on a similar list with no problems.... 2 6/7/2007 9:02:02 AM Mail merge: Can I limit how many emails are sent in a given time f I am using Word 2003's mail merge to send personalized emails to a couple hundred customers. However, my ISP limits the number of emails I can send to about 20 per 5 minutes before they start getting stopped. I have to do this quite often, so manually reducing my email list to under twenty and sending them out every five minutes is not really an option. Any suggestions would be greatly... 2 6/6/2007 6:45:05 PM Mail Merge Confirmation Once a mail merge via email thru Outlook is done, how do you verify if it worked? Do the messages appear in your 'sent' box? -- ht... 2 6/6/2007 6:37:08 PM why is my mail merge dropping my zero in front of my zip code?? ... 2 6/6/2007 1:07:26 PM URGENT! How to merge jpgs with an excel list into a name badge Hi, I've tried to find the answer here - but havent seen exactly what I need. Is there a way to merge pictures and text (from excel) into a label - or in my case a name badge. I can easily merge my excel list containing name and company into the Avery label - but I can't figure out how to "pretty up" the badge with my company logo/event name and an additional jpg. Is there some simple m... 2 6/6/2007 6:01:02 AM Blank pages s'more! Including a page 2 in my mail merge if a field is equal to Y; if field is equal to N, I don't want page 2; my IF statement has "" if 'if' fails, and it works, but I get a blank page instead. -- Marv Lusk ... 2 6/6/2007 6:00:31 AM eliminate trailing spaces in a mail merge field How can I eliminate trailing spaces on an individual merge field? The mail merge data source is directly from a mainframe-generated header-ed semi-colon delimited .txt file (Excel/Access not an option) where the fields are all a fixed-length, but the values are not always the maximum field length. (text qualifiers such as " are not used). I want to eliminate these spaces in the letter te... 2 6/6/2007 5:56:09 AM eliminate trailing spaces on a mail merge field How can I eliminate trailing spaces on an individual merge field? The mail merge data source is a mainframe-generated semi-colon delimited .txt file (Excel/Access formatting is not an option) where the fields are all a fixed-length, but the values are not always the maximum field length. (text qualifiers such as " are not used). I want to eliminate these spaces in the letter text. Ex. CA... 2 6/6/2007 5:21:45 AM Automating mail merge Hi! I apologize if this has been addressed before, but I couldn't find it. I have a directory with 216 .xls files. Each of these files needs to be merged with the same word mail merge document and the output named the same name as the .xls file just with a different extension [.doc]. I have tried [and failed miserably] to write this in vb. Any help would be appreciated. T... 1 6/5/2007 10:24:02 PM how to set up book spine labels? I want to set up a label template for my laser book spine labels in word 2007 but there is no template even close. It's the type of labels that have two sizes...one size for the call number and spine and another size for the bibliographic information. Anyone have any ideas?... 2 6/5/2007 7:05:54 PM Find in Field Help I'm using Office 2003. My merge source is FileMaker Pro acting as an ODBC data source (DataDirect 32-BIT SequeLink ODBC Driver) connected via an MS Query .dqy file. When I open my merge document, I can scroll through and merge any/all records just fine. But, when I try to Find in Field it will not find any records. However, if I click on Mail Merge Recipients and then click OK then ... 1 6/5/2007 5:54:03 PM Mail Merge/ Outlook 2003 - Zip Codes in Order I am having a problem that in Outlook - I cannot get the contacts to sort according to zip code. I have tried several times - to use the View Arrange By Current View Customize Current View Sort : Mailing Addresses But this still places several labels in the incorrect places according to zip code. Is there any way to correct this so that when I use the mail merge the labels are place... 4 6/5/2007 5:52:28 PM Names and address list in Excel-mail merge to Word for labels I have a spreadsheet with the following column headings Last1 First1 Last2 First2 Address City State Zip Smith John Jones Mary 123 Main St Anywhere NC 27777 I have the Block Address selected which would make the label John Smith and Mary Jones 123 Main St Anywhere, NC 27777 These labels as well as John and Mary Smith (when spouse has same last name) ... 2 6/5/2007 4:06:11 PM Mail Merge Date fields I have an excel datasource with dates formatted to show e.g. 5th June 2007. However when I merge the datasource in Word and insert the date field it shows as 06/05/2007. I am using Office 2003 on XP. My regional settings are set to UK. Is this common to set the date to American format. Is there a way to edit the mail merge field format to show the correct date format?... 2 6/5/2007 2:54:43 PM Listing the merge variables from all the dot documents Hi...All, I am a newbie to the Word Merge. I have close to 250 .dot documents & I have to find out all the variables that are used in these documents to do the merge. It will take time for me to open each one of them & find the variables (and I might miss some too). Which is the easiest way to process the documents & list the variables. Secondly the variables are marked {{home... 2 6/5/2007 9:15:49 AM Email Merge - Number Format vs Text It seems to me that in previous versions of office - if I pasted special values into my Excel merge data base it would flow through to the email merge - now I have to tediously type in $ and commas in text formatting in order to get the numbers to flow through properly. Otherwise it would just be 155553823.35 Does anyone know a better way?? I still want the commas represented in the ... 2 6/5/2007 8:53:47 AM Word 2007 CC: & BCC: recipients of e-mail merge In prior versions, I was able to select mail merge fields for the CC: & BCC: fields - how do you do that in Word 2007? (what do I have to buy to get that feature back) :(... 2 6/5/2007 8:47:58 AM Refresh Not Working Properly I have a mailmerge set up using an ACCESS Query connected via an ODBC connection to a SQL database. When I set the mail merge up originally, it worked fine and brought in all the records. The database has been updated and when I re-run the query in ACCESS I see the new records, but in Word, even after "Refresh" in the mailmerge, the new records fail to show up. If I re-assign the same... 5 6/4/2007 3:16:14 PM Why does Mail merge function freeze Word? The merge function in Word is horrible. I have not been able to successfully send a mail merge from Word. Every time, the program freezes. It sends maybe 5 emails and then Word is "Not Responding". Are there any suggestions to avoid this error? I have a POP3 account for Outlook. Does this have anything to do with it?... 2 6/4/2007 2:39:14 PM 168 Pages: <<  9  10  11  12  13  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  >>