Results 1 to 7 of 7
  1. #1
    daniboi is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2017
    Posts
    8

    Emailing Filled Form in a PDF

    Hi Everyone,

    I have an authorization form. Upon completing the form, i would like to be able to click on a button on that form that opens up outlook and attaches a pdf copy of that form to be sent out. How can i go about achieving that please and thanks?

  2. #2
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    As you self describe as novice - the easiest way to do this is to use the embedded method provided by Access:

    * create a report, option it to be Print Preview mode when it opens - with the layout & data that you want
    * instruct users to right click on rendered report on-screen and select 'Send To'

    the wizard will walk thru all the next steps

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Would recommend sending a Report, not a Form but I guess you can try. Might be something like below in the OnClick of button.

    DoCmd.SendObject acSendForm, "frmAuthorization", acFormatPDF, "Put your To Email here", , , "Authorization Form", , False

    https://msdn.microsoft.com/en-us/lib.../ff197046.aspx

  4. #4
    daniboi is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2017
    Posts
    8
    Thanks i will try that but alternatively, would the second option be to design the report in a form like manner and then display it for each "Authorization Request" and have that exported/emailed?

  5. #5
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Yes exactly, create a report based off the form record they complete and then email out the report from the button once the form record is saved.

  6. #6
    daniboi is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2017
    Posts
    8
    would you kindly guide me in creating the report based on as you said "off the form record they complete" please and thanks!

  7. #7
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    At the top of Access, select design and then Create Report and go through the report wizard. You will do the same as a form, select a table or query as the RecordSource, then add fields to the table., etc. Look on this site or youtube for examples on how to create reports if needed.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-12-2014, 02:34 AM
  2. Replies: 5
    Last Post: 10-04-2012, 07:40 AM
  3. Replies: 8
    Last Post: 08-02-2012, 02:53 PM
  4. Replies: 2
    Last Post: 03-14-2010, 08:21 AM
  5. Emailing a form
    By bailey537 in forum Programming
    Replies: 0
    Last Post: 07-16-2009, 03:45 AM

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