Results 1 to 7 of 7

Thread: Anyway to add Follow up to email??

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Long Island, NY.
    Posts
    353

    Question Anyway to add Follow up to email??

    I want to add Follow up by like 2 days or something, can I add that somehow?

    VB Code:
    1. stSubject = ":: Overdue Item :: -Supply-"
    2.     stSubject = stSubject & "  Freight # " & stTracking
    3.    
    4.     stText = "Here is the information for the overdue item at TMO." & Chr$(13) & Chr$(13) & _
    5.              "Tracking/Freight Number: " & stTracking & Chr$(13) & _
    6.              "Contract/PO Number: " & stContract & Chr$(13) & _
    7.              "Vendors Name: " & stVendor & Chr$(13) & _
    8.              "Description of Items: " & stDescription & Chr$(13) & Chr$(13) & _
    9.              "Received Date: " & RecDate & Chr$(13) & _
    10.              "Receiver at TMO: " & stReceiver & Chr$(13) & Chr$(13) & _
    11.              "Items belong to: " & stItems & Chr$(13) & _
    12.              "RAs Name: " & stRAname & Chr$(13) & _
    13.              "RAs Phone Number: " & stRAphone & Chr$(13) & Chr$(13) & _
    14.              "When picking up your item from Supply, please bring a copy of this email with you." & Chr$(13) & _
    15.              "This is an automated message. Please do not respond to this e-mail."
    16.  
    17.     'Write the e-mail content for sending to assignee
    18.     DoCmd.SendObject , , acFormatTXT, stEmailAddress3 & ";" & stEmailAddress, stEmailAddress4 & ";" & stEmailAddress2, , stSubject, stText, -1

  2. #2
    eltiT resU motsuC Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Anyway to add Follow up to email??

    you mean like automatically re-sending 2 days later??
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Long Island, NY.
    Posts
    353

    Re: Anyway to add Follow up to email??

    That would be cool to automatically send it 3 days later, but also I want the email to be flagged for Follow up. The option in Microsoft Outlook with the red flag... means user must follow up with this email in (2 days..)

  4. #4
    eltiT resU motsuC Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Anyway to add Follow up to email??

    You will have to program it in...
    The way you are doing now its not possible (Since u are using Access's built in command)

    you will need to add a ref to Outlook object library and actually Code it all in
    VB Code:
    1. Dim OTL As New Outlook.Application
    2. Dim oMail As Outlook.MailItem
    3. Set oMail = OTL.CreateItem(olMailItem)
    4.  
    5. oMail.To = "Person"
    6. oMail.Subject = "Subject"
    7. oMail.FlagDueBy = DateAdd("d", 3, Date)
    8. oMail.Body = "HELLO"
    9. oMail.Display
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  5. #5

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Long Island, NY.
    Posts
    353

    Re: Anyway to add Follow up to email??

    So add Outlook object library, then create a module and use this code? Then how do I call upon it?

  6. #6
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Anyway to add Follow up to email??

    Moved.

  7. #7
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Anyway to add Follow up to email??

    Quote Originally Posted by vonoventwin
    So add Outlook object library, then create a module and use this code? Then how do I call upon it?
    Put the code in a sub and call the sub.
    Tengo mas preguntas que contestas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width