Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Editing mail merge letters (Word 2002 (with Access))

    I have an Access 2002 database which uses Word 2002 templates files to mail merge letters. Problem is that I can't edit the letters because Word is requiring a data source - but the data source is a query that is dynamically built by the database. How can I make changes to the letter?

    Larry

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing mail merge letters (Word 2002 (with Access))

    Hi Larry:

    I haven't used 2002, so if it's changed then this may not apply.

    In Word 2000, a mailmerge in Word consists of 3 elements: a main document, a datasource, & a merged document. I'm not sure what you're trying to edit...the main document or the merged document. To edit the main document, which contains boilerplate text & graphics & instructions to Word (mergefields & Word fields), just open the main document & make your changes.

    If you're saying that there are no merge fields because the main document isn't attached to a datasource, then run your query & attach the datasource. Now you can change the main document's merge fields.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing mail merge letters (Word 2002 (with Access))

    Phil,

    Thanks for the reply - sorry to be unclear. There are merge fields in the file - the source document is an Access query, but Word doesn't recognize it when I open the source document for editting. Is this as easy as showing Word where the source query in Access is located? (this database was original developed in Access 97 using Word .doc files. When the database was upgraded to Access 2002, the VBA code wouldn't work with the .doc files, but I found a way to do it with Word template (.dot) files.

    Does this make sense?

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing mail merge letters (Word 2002 (with Access))

    Hi Imandel:
    If you want the final documents to be different, you edit the main document. If you're modifying the source document, I do recall reading posts here that Word 2002 is different than it's predecessors. However, I haven't had personal experience with it. However, if you click the search button at the top of the Lounge & search this forum (Word) for

    mail merge Access 2002

    you will see a number of threads describing problems and solutions. I wish I could be more direct, but as I mentioned, I haven't used Word 2002 yet.
    Hope this helps,

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Editing mail merge letters (Word 2002 (with Access))

    Unfortunately they improved on mail merge in Office 2002 and managed to break lots of things people were used to. You should however be able to use a plain old .doc as your primary merge document however. At least we done it with numerous documents where the data source is an Access database. And in fact, we do it on a generic basis with VBA. It's a pretty complex subject to dive into here, but we wrote an article for WAW with Helen Feddema last year that explored some of the nuances of Word merges and tinkered with the changes in 2002. Bryan Carbonnell has also written some articles for you can find from this <post#=162499>post 162499</post#>. The crux of the matter is that the default method for connecting to an Access database is now OLE DB instead of DDE, and that breaks things, in particular the use of parameter queries in general for Word merges. The way you've chosen to do the merges would require that you make the edits in the .dot template document, at least it would if I've correctly understood what you've done. If we can provide further info please do a follow on post in this thread.
    Wendell

  6. #6
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing mail merge letters (Word 2002 (with Access))

    <hr>Bryan Carbonnell has also written some articles for you can find from this post 162499<hr>
    Let me just clarify one thing that Wendell said.

    I did write a couple of articles about Automating Word from Access, but they do not deal with Mail Merge.

    Basically Article 2, the one that will probably be of most help, deals with taking a recordset and placing the data from a specific record into the Word doc a specific bookmarked locations.

    I find doing my "merges" easier this way, as opposed to using the Mail Merge function.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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