Results 1 to 2 of 2
  1. #1
    russ0670 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    21

    Help with Database User enteing database variable in text field for custom email.

    Hi i am trying to create a form where a user can type an emails content into a textbox with database variables.



    For example


    in the textbox the user would write

    ------

    Dear [Firstname] [Surname]

    Bla Bla Bla, regarding your property [Property address Line 1]

    -----

    on a onlick event
    This would send an email with the relevant data filled in.

    and the content of the textbox would be sent by filling the .htmlbody of a Set oItem = oOutlookApp.CreateItemFromTemplate(TempDir) method

    anyone know of a way, article or tutorial that could point me in the right direction?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,284
    Build a table to hold all your variables.
    build a form to enter the data.
    to email...
    https://www.accessforums.net/forms/e...nal-53335.html

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

Similar Threads

  1. Replies: 12
    Last Post: 03-27-2014, 04:49 AM
  2. Storing form text field to database
    By SlotMechanic in forum Forms
    Replies: 2
    Last Post: 08-03-2013, 05:39 PM
  3. Replies: 1
    Last Post: 07-20-2012, 05:35 PM
  4. Replies: 20
    Last Post: 08-08-2011, 01:34 PM
  5. update database using email body text
    By ravindramn in forum Import/Export Data
    Replies: 0
    Last Post: 05-19-2011, 06:34 AM

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 - Senior Forums