I have a co-worker having an issue with merging excel data into word and querying the data for specific information (both 2003 versions). When she does this, the first record is always the first line of data (even though the query should be excluding this line). It then skips the record...

Hi =?Utf-8?B?S2FyZW5T?=, Is it possible to set a default in the File Open dialogue box so that "All Files (*.*)" is the default? Version of Word? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)

I have created several documents that have mail merge. They are all using address books from Outlook in the public folders that are on the server. When I open the document after rebooting the system. The document ask the following: Opening this document will run the following SQL command: Select...

I created a catalog and needed to format the data in 3 columns instead of using tabs. When I did this I got an automatic page break after each record that I can't get rid of. I tried to make sure the break at the end of the column is a continuous break but that also did not seem to change the...

I have created a mail merge labels document. However along the top of the page appears a heading row : Last Name First Name Position... and under that a light grey bar running from the left margin to the right mergin. Both interfere with the top row of each label sheet. How do I turn that off...

I have all of my data for my merge in an excel spreadsheet. For good reasons, the spreadsheets has the information in several worksheets (but all in one file). Is there a way to do a merge that will include all of the worksheets? I have to do toooooo many merges to merge all of the data,...

I would like to print labels using different address on one sheet. Is this possible? -- Stop

I already posted this problem but there have been some new developments and I can't find my origional post. Sorry for the trouble. Word 2002 10.6612.6714 SP3 / Excel 2002 10.6501.6714 SP3 / WinXP Pro SP2 I am cataloguing DVDs and DVD packs for my company. Each individual item needs to be put...

How do I get mail merge to print one record per label? Only printing one record for whole page of labels instead of one record per label.

Hello, Note: This post involves GoldMine CRM software's interaction with Word 2000, but the functionality I am working with is in Word. I am able to get Word 2000 to include pictures in labels in a merge by using {INCLUDEPICTURE "C:\\folder\\image.gif"} as a merge field. during merge, I would...

I'm trying to merge some currency field into a document. In the document as it stands, the figures will show up correctly, i.e. $14,112.30 for instance but then I saved the word document under a different name and added the same query as the data source but when I insert the mergefield i...

My labels created on from mailmerge look OK, but when I go to print the are not aligned properly. I specified AVery Label type 5162 and also inserted said form for printing - but the top address line prints abot the label section. I also experimented with another label type (i.e. Avery 5160)...

I have two questions. I have created a mail merge from Outlook into Word and have setup the fields properly. I can view one record set at a time. I can scroll through them with the "Next Record" bottom but of course I want to view all the records together. (I am creating a Contact list booklet). I...

I am trying to use the Suffix field from Outlook in a mail merge letter but it shows up as "not matched". When I try to match it with the correct field, there is no field "suffix" available for mapping. Any suggestions?

Hello, I am trying to do a Mail Mege with VB6 and MS Word 2002 which will work fine for the first one document. However, if I select ther merge document a second time it blows on the OpenDataSource statement with the error "The remote server machine does not exist or is unavailable". I found...

Why does the date format change from "English" to "American" when I conduct a mail merge from an Access or Excel database to a word document. My computer settings all show the time format as "English".

Not sure if this went out the first time, so I'm sending again. How can I print out a hard copy of my mail merge recipients with all fields shown? Kinda like a excel sheet.

Hi, I've been using Excel since 1.1 around '87 and have written many macros. Earlier this year I set up a macro in Word 2000 to merge various Excel address lists. Since I know zilch about Word I copied most of the info from an MS KB article and modified it. I had problems it getting it to pick...

I live in Japan where addresses routinely run longer than five lines. In addition anything I send to the US usually requires more than five lines. When using Envelopes and Mailing tab, I can highlight as many lines as I like, but MS only prints out the first 5. If that's what you insist on,...