Results 1 to 8 of 8

emaildatabaseobject message formatting

  1. #1
    Poohbear0471 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    19

    emaildatabaseobject message formatting

    I have an email button to send email notifications of new or updated records (using the Access 2010 Call Tracker template, Call Details form). Two questions...

    From what I've read, it is not possible to include any attachments from the record into the email, correct?

    How do format my message to include paragraphs, etc? Do I just need to use a format other than plain text?

    Click image for larger version. 

Name:	pic27018.gif 
Views:	16 
Size:	20.3 KB 
ID:	36906



    Thanks!

    Ed

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    19,333
    If you mean attachments from the attachment data type, I don't think so but I don't/won't use that. I don't use macros either, but I think you can concatenate Chr(13) & Chr(10) into the string for a line feed. For more complicated formatting (bold, etc) you'd have to switch to a VBA method where you can use html body.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,854
    Requires VBA manipulating Outlook objects to attach files to email. If the file(s) are in attachment type field, must first extract to external folder location.

    Most experienced developers do not embed files into database. The above situation is only one reason why. Another is that files quickly use up Access 2GB file size limit.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  4. #4
    Poohbear0471 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    19
    Paul,

    Thank you very much for your help. The Chr(10) was all I needed to include to get the line feed.

  5. #5
    Poohbear0471 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    19
    June7,

    How do you recommend handling attachments? As linked documents? That would certainly avoid the 2gb limit and would be simple enough to implement.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,854
    Save full file path/name in text field. Or build path with an expression. As example, say you have employee JPG images in a folder sitting next to database and EmployeeID values are used to name image files. To display images in an Image Control on form or report, Image Control ControlSource property can be an expression:

    = CurrentProject.Path & "\Images\" & [EmployeeID] & ".jpg"

    However, if this is a split db with frontend installed on each user workstation, CurrentProject.Path won't work. So if Images folder is on server:

    = "\\servername\folder path\Images\" & [EmployeeID] & ".jpg"

    Building path string for file to attach to email can follow similar structure.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  7. #7
    Poohbear0471 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    19
    Awesome! Thank you very much for your help!

  8. #8
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    19,333
    Quote Originally Posted by Poohbear0471 View Post
    Paul,

    Thank you very much for your help. The Chr(10) was all I needed to include to get the line feed.
    Happy to help!
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

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

Similar Threads

  1. EmailDatabaseObject
    By mick3911 in forum Macros
    Replies: 3
    Last Post: 08-07-2018, 03:03 PM
  2. EmailDatabaseObject Help
    By jimaccessnovice in forum Macros
    Replies: 4
    Last Post: 02-27-2018, 03:51 PM
  3. Replies: 15
    Last Post: 09-26-2016, 03:14 PM
  4. emaildatabaseobject with date?
    By vicsaccess in forum Import/Export Data
    Replies: 5
    Last Post: 10-19-2015, 04:55 PM
  5. EmailDatabaseObject in Macro
    By Kmoney in forum Programming
    Replies: 5
    Last Post: 01-13-2012, 02:14 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
  •  
Tech Forums: Microsoft Office Forums