Results 1 to 6 of 6
  1. #1
    ACu is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2018
    Location
    Mississippi
    Posts
    8

    Post Adding a Word doc to a Form using a button

    How to access an existing Word doc from a button on a Form to do a mail merge.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    This is a fairly common topic and many tutorials on web. Here is one https://rtmccormick.com/2015/11/23/a...ba-and-access/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ACu is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2018
    Location
    Mississippi
    Posts
    8
    How to create a letter in Word that will populate data from a form in Access. This letter will be constantly used over and over. The data used in the letter will be an email, date, time and number of persons from the data base form. I also want this letter to pop up with a button on the form. How do I do this?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    I have never had to do mail merge. Doesn't the referenced link provide example code?

    Why do you need to use Word at all? Will an Access report not provide the same result?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,654
    Albert Kallals' super easy word merge may be a good starting point. http://www.kallal.ca/msaccess/msaccess.html
    it may not be what you want but picking through the code may help.
    I agree with june7 however that it seems an unnecessary step.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,980
    I have used mail merge for various purposes over the years.
    This was normally where the required output / layout was too complex for Access reports.
    In such cases, I also found Albert Kallal's super easy mail merge very useful.
    The code is complex but it's implementation is easy.
    It is also customisable if you need to modify it...but I doubt you will need to do so.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 12
    Last Post: 09-19-2017, 02:38 PM
  2. Replies: 1
    Last Post: 07-26-2017, 01:25 PM
  3. Replies: 3
    Last Post: 01-05-2016, 12:25 PM
  4. adding word documents and pdf's to a form
    By Firemann25 in forum Access
    Replies: 2
    Last Post: 04-22-2015, 08:44 AM
  5. Replies: 1
    Last Post: 03-05-2013, 02:37 PM

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