Results 1 to 8 of 8
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    Program Link to Outlook Email from a Buttom


    Hello i want to create a button, and when a user clicks it, an email template from outlook will pop open with default list of people to send to and a filled in subject line. id appreciate any help thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    There is lot out there on this topic. Google: VBA Access Outlook email multiple addresses.

    Here is a recent thread on the topic https://www.accessforums.net/import-...ort-18235.html
    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
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    thanks! i was able to solve this

  4. #4
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    actually, i was able to get the email open but how do i add more stuff to the body? such as how do i make it so i can go to the next line of the email without having to continue from the first line? also, how would i make something bold or another font color? or italicis? thanks

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Do you want to build the body from data in database or just hard-coded in the procedure, like:

    .HTMLBody = "This is my message with multiple lines." & Chr(10) & Chr(13) & "This is second line."

    Assigning color and fonts I think requires HTML tags. Never tried that. See http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
    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.

  6. #6
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    hello, i tried using that line of code but it still writes it on the same line? also im not sure if this has anything to do with it but im usign access 97 and it wont recognize the olFormatHTML from that link when i put in:

    .BodyFormat = olFormatHTML

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I have never used Access 97. If it won't work with HTML then don't know if you can do what you want. Although I have not tried using HTML tags in email code, I have tested the CR LF codes with success in Access 2007.
    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.

  8. #8
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    i see, thats ok. thanks for the help anyways!

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

Similar Threads

  1. email with outlook.application
    By JJCHCK in forum Access
    Replies: 5
    Last Post: 08-25-2011, 06:19 AM
  2. Replies: 2
    Last Post: 07-29-2011, 12:33 PM
  3. Passing Email Address Into Outlook
    By cg1465 in forum Access
    Replies: 1
    Last Post: 10-01-2010, 07:59 AM
  4. Exporting Outlook email addresses
    By noidea in forum Import/Export Data
    Replies: 0
    Last Post: 08-01-2009, 01:48 PM
  5. Access link to Microsoft Outlook
    By epallaron in forum Access
    Replies: 0
    Last Post: 09-19-2007, 07:25 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