Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Feb 2002
    Location
    Jupiter, FL, USA, Florida, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    edit mail merge database (Word 2002)

    Can anyone tell me how to edit a mail merge database? <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    If I open the mail merge recipients list, then highlight a name and click on "edit," I get:

    "This operation cannot be completed because of dialog or database engine failures. Please try again later."

    I need to figure this out in a hurry. I've tried the help files within the program and on the MS website, but I can't seem to locate an answer. <img src=/S/read.gif border=0 alt=read width=19 height=33> I guess no one makes changes once they've saved the file. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Thanks.

  2. #2
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: edit mail merge database (Word 2002)

    Word 2002 creates an Access table for data. Previous versions used a Word table. I have found that if I open Access I can edit it there. It's kind of tricky to open the file; by default the file is stored in a folder called "My Data Sources".

    HTH
    egghead

  3. #3
    Lounger
    Join Date
    Feb 2002
    Location
    Jupiter, FL, USA, Florida, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: edit mail merge database (Word 2002)

    Thanks, but how do I edit the info? I know where the file is located, but I do not have Access. What do I do? I need to know exactly how to edit the file. I have to delete, add, and change some of the current info.

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: edit mail merge database (Word 2002)

    Hi Teresa
    I have given up looking for that answer.
    I have customised the mail merge toolbar to include previous word merge tools. I instruct others NOT to use the task pane to create data sources but to use word tables or excel instead.

    Consider the situation where a common data source is repeatedly used and one selectively mail merges. Try & extract a list of recipients to file with the std letter under Word 2002. Forget it.
    I can only put it down to a plot to sell extra Access licences.

    Best of luck
    Geof

  5. #5
    Lounger
    Join Date
    Feb 2002
    Location
    Jupiter, FL, USA, Florida, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: edit mail merge database (Word 2002)

    Thanks, Geof, for taking the time to try to figure this out. This is another great reason why I prefer WordPerfect. To me, WordPerfect is to Word as Quark is to Publisher. Unfortunately, I have no choice about working in Word since most of my clients use it. I could have saved myself, and you, so much time if I'd been able to use WordPerfect, but my client needed this database in Word.

    I have Access 2000, but have never used it and haven't put it on the new computer. Seemed too complicated for what I needed to do, so I didn't buy the 2002 version. I guess it would be safe to enter data in either a Word table or Excel since my clients should have Excel if they have Word. Thanks for the tip.

    Well, now I guess it's on to getting the data redone...somehow. Next time, I'll know better. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    Thanks again.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: edit mail merge database (Word 2002)

    You should be able to get the data into an Excel or Word table, even without installing Access.

    In Excel, use the External Data item in the Data menu and then New Query (I don't know the exact captions in English).

    In Word, display the Database toolbar and click the Insert Database button.

    After importing the data, you will be able to modify them.

  7. #7
    Lounger
    Join Date
    Feb 2002
    Location
    Jupiter, FL, USA, Florida, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: edit mail merge database (Word 2002)

    Thanks, Hans.

  8. #8
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: edit mail merge database (Word 2002)

    Thanks for that Hans
    I should have thought of that earlier..
    With the insert database field one is able to filter the data source to provide the list to file with the standard letter.

    I think I will stick with my view of having users create their datasources in excel or word rather than the task pane wizard.

    Cheers
    Geof

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •