Results 1 to 4 of 4

Emailing the available attahcment in table using macro.

  1. #1
    Muralidaran is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    2

    Emailing the available attahcment in table using macro.

    Hi everyone...
    Good day!!!
    I have question regarding the attachment in Access 2010.
    I have a table name called NewJobsTbl and i have column for attaching some pdf drawings to it at the time when we receive the Fabrication drawings in PDF format.

    Now my requirement is when i am releasing the particular job for fabrication i will update the PO release date and from there i have created a macro that works after updating the records and the PO release column has today's date it will send send an email to the concerns mentioning the job release.

    I am utilizing this for the past 2 months and some of my staffs they are asking for the fabrication drawing along with that mail then i am started doing the both the things, first when i update the date macro will send an mail, and i will write a personal mail using outlook attaching with that fabrication drawing.

    Is there any way to forward the available attachment with that particular record along with the mail which has been created by the macro.

    Your support will help me a lot and thanks in advance and sorry i am not attaching the sample database since web site doesn't allow me to load file size 650 kb.

    Regards
    Ram.

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    30,628
    Windows Compression zip of 2mb allowed.

    I don't know if an item from attachment field can be extracted and attached to email. Sounds difficult. Not finding any code for that. It would be easy to attach an external file to the email.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    Muralidaran is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    2
    Dear June7,
    As i have mentioned i just wanted to attach the particular attachment through the macro, i do know that i can attach it manually in outlook, is there any chance for that?

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    30,628
    Is the attachment from an attachment field in Access table?

    I don't use macros, only VBA. I have code that attaches an external file to an email. Review http://forums.aspfree.com/microsoft-...ro-447084.html
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

Similar Threads

  1. Login Security w/ Macro Builder and Table
    By benthamq in forum Programming
    Replies: 14
    Last Post: 01-28-2013, 01:51 PM
  2. Replies: 11
    Last Post: 11-07-2011, 09:29 AM
  3. Replies: 2
    Last Post: 11-02-2011, 07:31 AM
  4. Macro to trigger emailing an updateable table
    By KOIBOY in forum Import/Export Data
    Replies: 5
    Last Post: 09-10-2011, 04:46 AM
  5. Replies: 0
    Last Post: 08-25-2008, 11:17 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
  •  
Tech Forums: Microsoft Office Forums