Mail merge selects wrong data



  • 1. merge to e-mail
    I am using Word 2002 and trying to merge to email (in HTML format), with no joy - no messages are produced. It works fine in plain text format. I am using Eudora, but also tried with Outlook and got same thing - any bright ideas?? .
  • 2. How can I test for the last record printed in a merge
    I am using a catalog to print multiple records from Access into a single letter in Word. To have and opening paragraph, I check if MERGESEQ = 1 and if it is, Word adds the opening paragraph. After the last record of data is printed in the body of the letter, I would like the concluding paragraph to be printed. How can I have word check if the last record was printed? The number of records printed in the letter is always different, so I can't check if MERGESEQ or MERGEREC = a specific number.
  • 3. Mail Merge from Multiple Datasources
    I have related data in two seperate but releated Access tables but it appears that I can only slect one source. If I query the two sources I get the data from the one table repeating for each line of the other table. These tables have a one to many relationship and I want header data from one table and multiple rose from the other on the merged page.
  • 4. Directory in Mail Merge Word 2003
    I am developing a telephone directory for a 1200 member association. I have about 15 fields that I am merging from an excel file i.e. First Name, Last Name, Mailing Address, City, State, Zip etc... Because some members do not want any information published some of the members will have more information than the other. I merged the data and then put it into four columns, however I noticed that the names did not line up on the top of the page, in other words one members name is at the end of one column and their address is at the start of the next column. Is there a way to line it all up or will I have to go into each column and manually enter spaces so it lines up. I hope you understand the question. I'm not sure if there is a way since all records are not equal in size in the directory.
  • 5. Mailmerge from Excel document with multiple criteria selections ne
    I have an excell document with the following columns: "OrderSort;NameSort;Acct#;Type;Name1;Name2;Street;SSN;Shares" I need to group data according to Street Address, then Name1 and/or Name1/Name2. If Name1 (Sally) has three accounts at same street address, all three lines of info goes on one page. If there is a second Name1 (Jeff) at that address, his lines of info go on a seperate page, If there is a Name1 and Name2 (Joint account) at that address, it goes on yet another page. Then the next address gets sorted, then the next. etc.... I need for Word to merge 1 group of data onto my one page/template and then take the next group of data and start a new page using same template, then next group on next page, etc.... Is there a way to do this?! (I could post an acutal sample file of my data if someone tells me how)

Mail merge selects wrong data

Postby Simonb » Mon, 08 Mar 2004 20:37:10 GMT

Hope this query makes sense - my first post..

I'm using Word2003 mail merge to add address block into 
standard letters. Data source is Excel 2003 XLS, & I'm 
using "advanced" filter facility within mail merge.

At step 3 of 6, I browse to correct tab within XLS and 
all data is displayed correctly. I then select "advanced" 
filtering in column headings, because I want selection: 
col A = "N" AND col B = blank AND col C = not blank.

Data is filtered correctly, so I press OK and carry on 
with mail merge. At step 5 I find that too many records 
have been selected because the filter table has been 
corrupted - for example it now says col B = blank AND col 
B = not blank, so it selects nearly all records!

Any suggestions? My only workaround suggestion is to use 
Excel to do the filtering, then copy the filtered data to 
another tab and merge without using the WORD2003 filters.

Any other ideas? I'll be very grateful for any 

Similar Threads:

1.Mail Merge Labels: selecting the data source


Not sure if this will help, but when merging from Excel make sure you only 
have the column headings and then the data with nothing above the column 

Hope this is helpful for you 

"Sam" wrote:

> Hi there!
> I just wanted to set up labels for a mail merge and when I browse for the 
> database, for some reason I cannot use my database (excel). I can choose the 
> file, select the table but then again another "select table" window opens 
> where I cannot choose any table (empty) or no matter which workbook I choose, 
> it always says "word was unable to open the data source".
> Any suggestions? I used the same format yesterday with a different excel 
> file and everything was fine.
> Thanks a lot,
> Sam

2.mail merge crashes when I select data source

Word and Excel 2003   I am setting up a new mail merge.  I open the document 
I want to use (not yet tied to a database)  I open tools, letters and 
mailings, mail merge, letter, I select "current document", next I select "Use 
existing list", I browse to the correct file and select it.  It opens and 
word closes.  Does anyone know what is wrong?  Thanks!  Carol



Working in Word XP, Mail Merge...  set to access XP db for data...  all goes well till I go to "Select Recipients" to choose what records I want merged.  When the wizard pops up and shows the check boxes for who to include or not include, the table (bd) data shown for the sorting (under headers) is scrambled.

In the name field maybe part of the address, in the description filed maybe part fo some other fields...

So when I want to sort or select recipients by a certain header (field) I cant tell what is what since the data in the colums is from other foelds and is in the wrong place.

So in short when I go to select recipients, the data that it shows in the popup is not lined up in the correct colums...  its scrambled like the word doc and the dbase arent in sync...

Im pretty desperate, so if you can help please do !!!!


What Ive tried:

Repair DB
Reinstall office
100% patched
exported to Xcel then imported to access again
redid the document from scratch

4.mail merge and outlook, wants me to select data source

When I select Outlooks Contacts, screen jumps to select data source instead 
of showing the names, Why. 

5.mail merge can't locate my data source which IS mail merge

i created a recipient list IN mail merge some months back, but now when i go 
to merge print labels the wizzard does not display any option to use that 
list.  i found lots of info on merging with excel or outlook, but how do you 
merge with mail merge??!!

6. wrong font being sent in e-mail mail merge

7. Mail Merge Format Wrong in Merged Document

8. MAIL MERGE (started from Outlook) tries 2 merge using the WRONG d

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 29 guest