Mail Merge

Microsoft OFFICE

    Sponsored Links

    Next

  • 1. Differing versions of Home and Student Office 2007
    Hi, I have noticed that there are differing editions of Microsoft Home and Student 2007. I have seen one with a listed date of 01/07 and the model number 79G-00007 and one with a date of 07/09 and a model number of MSO79G-01153. I understand that the first one can have 3 PCs on the license I am not sure of the later. Is there any significance to one over the other. There is about a $50-60.00 difference in price.
  • 2. Upgrading to a new computer
    My new computer is running Vista Ultimate 64 bit. My old computer is running XP professional. I have Office 2000 professional running on the old computer. I want to install Office 2007 Professional (upgrade) on the new computer. Is there any way I can install Office 2007 on the new computer without having Office 2000 running on it? I understand that Office 2000 may not run correctly on a 64 bit OS is would be a real mess if I must have it installed before the upgrade version will work. By the way I have all the original disks, product keys etc. if that will help. Thanks to any one who know the answer to this.
  • 3. Office 2007 SP2 fails to install with error Ox78F
    Running XP this update has failed every time I have tried to install it. I took some suggestions found in some threads like putting my disc in the machine but nothing seems to work. At least part of the error report refrences the c|DOCUME~ temp file and also mentions \temp\MAINWWSP2_MSPLOG Also \Temp\opatchinstall(3)log. Event type: instmsp Any ideas? Thanks
  • 4. Getting error code 0x80070643 when updating Office 2003
    Microsoft Update identifies updates required for KB947319 and KB972688. These are downloadewd OK, but installation fails - I've tried several times on two PCs (both running XP).

Mail Merge

Postby RG91Zw » Tue, 11 Mar 2008 23:31:01 GMT

I seem to be having a problem opening Mail Merge documents created in Office 
2000 with Office 2003.  Specifically, I have a database created in Access 
2000 into which I input data and then merge the results by having the Access 
program bring up a Mail Merge document and merge the data.  Some of the 
workstations have been upgraded to Office 2003.  When one of these 
workstations brings up the Access database (now opened with Access 2003), 
they are able to input the data as usual.  But when they try to bring up the 
Mail Merge document, it opens the document but states it is not a mail merge 
document.  Of course it cannot procede.  If I debug when it suggests, it is 
still looking at the mail merge document we have always used. The place where 
it stops and is highlighted is 

      End With
                objWord.ActiveDocument.MailMerge.Execute

       If I close everything and then use Word 2000 OR Word 2003 to open the 
document it comes up as a mail merge document and tells me that it has to get 
information from the database before it can procede.  I am perplexed to say 
the least.   There are many of these mail merge documents in exitance and I 
dread going back and recreating them in Word 2003.  No.  I haven't tried 
that.  I did open the document with Word 2003 and save it with Word 2003.  It 
still cfeates the same error.   The mail merge still works using Office 2000, 
so I have some leeway.  But I need to get upgraded.  Help?
-- 
Doug

Re: Mail Merge

Postby Bob Buckland ?:-) » Fri, 14 Mar 2008 00:21:47 GMT

Hi Doug,

You may want to use the link below to also post this in the MS Word Mailmerge discussion group if you're running the merge from
Word.

================


I seem to be having a problem opening Mail Merge documents created in Office
2000 with Office 2003.  Specifically, I have a database created in Access
2000 into which I input data and then merge the results by having the Access
program bring up a Mail Merge document and merge the data.  Some of the
workstations have been upgraded to Office 2003.  When one of these
workstations brings up the Access database (now opened with Access 2003),
they are able to input the data as usual.  But when they try to bring up the
Mail Merge document, it opens the document but states it is not a mail merge
document.  Of course it cannot procede.  If I debug when it suggests, it is
still looking at the mail merge document we have always used. The place where
it stops and is highlighted is

      End With
                objWord.ActiveDocument.MailMerge.Execute

       If I close everything and then use Word 2000 OR Word 2003 to open the
document it comes up as a mail merge document and tells me that it has to get
information from the database before it can procede.  I am perplexed to say
the least.   There are many of these mail merge documents in exitance and I
dread going back and recreating them in Word 2003.  No.  I haven't tried
that.  I did open the document with Word 2003 and save it with Word 2003.  It
still cfeates the same error.   The mail merge still works using Office 2000,
so I have some leeway.  But I need to get upgraded.  Help?
-- 
Doug >>
-- 
Please let us know if this has helped,

Bob  Buckland  ?:-)
MS Office System Products MVP

  >>*Courtesy is not expensive and can pay big dividends<<

LINKS
A. Specific newsgroup/discussion group mentioned in this message:


    or via browser:
    http://www.**--****.com/ 

B. MS Office Community discussion/newsgroups via Web Browser
     http://www.**--****.com/ 
   or
    Microsoft hosted newsgroups via Outlook Express/newsreader






Re: Mail Merge

Postby RG91Zw » Fri, 14 Mar 2008 04:39:02 GMT

Posted there too now. Thanks, Bob
-- 
Doug









Similar Threads:

1.Code launches Mail Merge but disables the Mail Merge

I've got a Mail Merge doc based on .xls via DDE. When manually openeing
the file i need to confirm that the sql will be run. Now i've written a
code to launch the mail merge doc from Excel but the problem is that by
launching it this way the sql gets disabled (no warning appears - i'm
not getting prompted at all) and thus the Mail Merge gets disconnected
from the underlying .xls file... Any ideas how to keep the Mail Merge
running and connected to the .xls?

The code
Sub Open_MMerge()
Dim wrdApp As Word.Application
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
wrdApp.Documents.Open ("C:\Mail_merge.doc")
wrdApp.Activate
Set wrdApp = Nothing
End Sub


Thanks,

A.

2.Word 2000 Mail Merge: Word found no mail merge fields

Hello everybody,

As the subject says, I am trying to create a form letter in Word 2000
from an Excel 2000 spreadsheet, but when I try to to open the data
source, I get the following error: "Word found no mail merge fields in
your main document".  How do I create mail merge fields?  Can anybody
help me?

Thanks in advance.
Brian

3.Mail merge hang, MS Word 2000 mail merge to MS Excel

A few days ago, MS Word 2000 stopped mail merging documents. The
symptom is as follows: When MS Excel is invoked to read the data
source, MS Word hangs saying either "Initiating DDE connection to
Microsoft Excel" or "Starting Microsoft Excel" on the status line. One
can replicate this by generating a new spreadsheet (test.xls)
containing any nine numbers in a square, saving it, starting a new MS
Word document, selecting Mail Merge, and selecting test.xls as the
data source. After about 2 hours (!) the box asking whether I'd like
to select the entire worksheet as a source comes up. This used to work
immediately. The only thing I installed between the two instances was
a minor HP printer driver update. Web reports suggest it fails
randomly. If "Select merge source" is selected (to avoid DDE), I can
import successfully using the converter. ODBC fails silently. However,
it appears to be impossible to load existing saved documents with
merge sources as I can't select the converter.

I have once or twice got "Word could not re-establish a DDE connection
to Microsoft Excel to complete the current task."

I am running Word 2000 Standard SP-3 fully patched on XP fully
patched.

To correct this I have tried the following (gleaned from the web):
1. Repairing the existing installation, and rerunning with "/
regserver"
2. Removing the entire Office installation, rebooting, reinstalling,
loading all service packs, rebooting.
3. Renaming registry keys so these get reinstalled, renaming all
instances of normal.dot, removing contents of word and excel start up
directories.
4. Ensuring "ignore other applications" is not set to "on" in Excel
5. Replicated with new documents (see above) to check it's not
corrupted documents. Loaded documents that hang on this machine on
another machine running seemingly identical software, where they work
perfectly.
6. Searched MS knowledge base.
7. Ensured no files in My Documents are set to "read only" (tip from
the web).

Putting a simple DDE field to call Excel into Word also hangs it. I
think the problem may be that DDE from Word has ceased working
entirely.

Any ideas?

4.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??!!

5.Advantage of Mail Merge 2003 over Mail Merge 2000

6. word 97 mail merge vs word 2002 mail merge

7. mail merge doc with further linked/embedded mail merge docs not playing the game

8. Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 F



Return to Microsoft OFFICE

 

Who is online

Users browsing this forum: No registered users and 57 guest