Results 1 to 4 of 4
  1. #1
    eadeane7 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    3

    Need a macro for Access 2010 web form to do word mail merge.

    This is a two part issue. First using only built in macro functions allowed in Access 2010 web database, I need to launch Word from a web form and perform a merge of current data being displayed.


    Second the data is client base , but I need to display multiple records for one client and would like to do this in a three column table in the middle of the word doc. I wish to limit each column with 7 records. So I have header info pertaining to the client and then in the middle to display the multiple records in a grid form, then on the bottom display the remaining data from the same record being displayed in the header or top of the word doc.
    Interesting to say the least. Any help would be greatly appreciated.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Have you tried creating a report?

  3. #3
    Missinglinq's Avatar
    Missinglinq is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Everyone be aware that this is double-posted at

    http://www.utteraccess.com/forum/Mai...-t2013580.html

    eadeane7, have a look at GroverParkGeorge's response, there.

    A dozen-and-a-half, or so, members have read your thread, here, with a like number on the UA site, but George has been the only to respond. Don't want you to think that we're ignoring you, but the simply fact is that few of the experienced developers, here, use Embedded Macros, and most who have databases on the web use another language, for the web portion, instead of a native Access web database.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    eadeane7 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    3
    Quote Originally Posted by ItsMe View Post
    Have you tried creating a report?
    I have, but web reports are very limited. You cannot do things like sub-reports, which I would need to handle the one to many presentation of the data I wish to display. Thank you for your response.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-10-2012, 05:51 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

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