Results 1 to 2 of 2
  1. #1
    besuchanko is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    32

    Access Query to Word Merge

    Would someone be able to provide a super brief example of code? I have a query called PresenterDataReport that contains the data I want to use in form letter. I want to do this with VBA automation to Word. All the examples I've seen assume that a template has already been created in Word. I don't want to do that. I want the VBA code to generate the actual letter by inserting the fields from my query and the strings of text - all from within the VBA code (no template). How do you do this?? I'd like to also be able to apply formatting (bold, italic, etc.) to any of the query data or strings of text. I've been successful with doing this to Excel, but now I need to tackle Word.

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Word Demo

    Here is a sample db that should get you started.
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-16-2012, 05:55 PM
  2. Mail merge from from Access to Word
    By williamgladstone in forum Access
    Replies: 1
    Last Post: 03-22-2011, 12:00 PM
  3. Access Query mail merge to Word
    By Jan Collier in forum Access
    Replies: 8
    Last Post: 08-30-2010, 09:52 AM
  4. Access / Word mail merge problem.
    By PD1117 in forum Access
    Replies: 0
    Last Post: 07-06-2010, 09:41 AM
  5. Mail Merge from Access to Word
    By Rachelkm2 in forum Programming
    Replies: 1
    Last Post: 05-29-2009, 02:49 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums