Results 1 to 2 of 2
  1. #1
    imav is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    1

    How to Import Outlook emails with embedded images

    Hi all,

    Thank you for allowing me to make my first post on your forum.

    I have a small question that I have been going crazy over all week. I have intermediate VB experience but need some help. I keep getting the Long Binary Data error message...



    I am trying to import a folder from Outlook to an Access table. (easy)
    But in the body of the email I have a few lines of text and then an embedded image of the client.

    My question is, How can I import these emails into Access and have Access import the Text AND the Image? The image is not an attachment it is just in the body of the email.

    Thanks in advance,

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    a table in a database has for each field - a defined field type; text, number, date, etc.

    one can't import an image into a non image field type. when 2 types of data are co-mingled as you describe - then you will need to manage that into 2 fields.

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

Similar Threads

  1. import excel spreadsheet though outlook
    By bopsgtir in forum Import/Export Data
    Replies: 0
    Last Post: 03-18-2011, 09:07 AM
  2. How to import specific Outlook contacts into Access?
    By Chevalier in forum Import/Export Data
    Replies: 1
    Last Post: 12-05-2010, 02:41 AM
  3. import custom form data from Outlook
    By bigsteve520 in forum Import/Export Data
    Replies: 0
    Last Post: 11-13-2009, 12:18 PM
  4. Replies: 17
    Last Post: 08-26-2009, 11:27 AM
  5. Access Report and embedded images
    By joypanattil in forum Reports
    Replies: 0
    Last Post: 11-22-2008, 03:50 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