1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Emailing database forms

Discussion in 'Business Applications' started by Nickaqua, Apr 17, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. Nickaqua

    Nickaqua Thread Starter

    Joined:
    Apr 17, 2010
    Messages:
    5
    Hi

    I would like to email multiple forms to multiple recipients respectively, in Access 2002 as shown in the attachment.
     

    Attached Files:

  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Nickaqua, welcome to the Forum.
    What you want to do it possible using VBA code.
    Do you know how to work with VBA code?
     
  3. Nickaqua

    Nickaqua Thread Starter

    Joined:
    Apr 17, 2010
    Messages:
    5
    Hi

    Not sure how to use VBA Code

    Nickaqua
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I can help you with the VBA code, but I will need to know the exact names of the tables and fields invloved.
    Are you using a Word Document as a an Attachment, or creating a simple email?
     
  5. Nickaqua

    Nickaqua Thread Starter

    Joined:
    Apr 17, 2010
    Messages:
    5
    I just want to send the form(s) in attachments to their respective recipients.
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Well you can email a Form, but it sends all the Records to every Recipient. I don't think that is what you want to do, is it?
    It also Sends it looking like a Table.
     
  7. Nickaqua

    Nickaqua Thread Starter

    Joined:
    Apr 17, 2010
    Messages:
    5
    It's mainly to send each actual form to its respective recipient.
     
  8. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Perhaps you mean email some data from the Record on a form to the person that record is about?
     
  9. Nickaqua

    Nickaqua Thread Starter

    Joined:
    Apr 17, 2010
    Messages:
    5
    Please see the form I'm referring to. I couldn't send the actual database that generate the form to see how it was created.
     

    Attached Files:

  10. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I see, you mean a copy of a paper form, not an Access Form.
    If the form is a word Document it can be filled in by the Database providing that "Bookmarks" are used, it can then be emailed as an attachment.
     
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/917539

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice