39 Responses

  1. Project: Retrieve Files From Remote Computer Through E-mail | My Technophilic Musings

    […] Remote File Access Through E-Mail […]

  2. Rohit Khurana
    Rohit Khurana at |

    fundooo!!!!
    Thats cool !

  3. Retrieve any file on your home computer by email « Sam’s blog

    […] Don’t have a Mac, windows users click here for similar […]

  4. Retrieve Any File on Your Home Computer via Email, Windows Edition [Remote Access] · TechBlogger

    […] great way to retrieve the file you forgot, and you can retrieve it anywhere you have email access. Remote File Access Through E-Mail [My Technophilic Musings via […]

  5. llcooljayce
    llcooljayce at |

    When you set up the macro in Outlook, I’m assuming you set up a new macro name, I used ‘remote’

    So then you you hit create and you get the following code:

    Sub remote()

    End Sub

    Are you supposed to paste your code in between the sub and end sub? Like so:

    Sub remote()
    Attribute VB_Name = “Module1”
    Function mail(strTo As String, _
    strSubject As String, _
    strMessageBody As String, _
    Optional strAttachments As String) As Boolean

    Dim MAPISession As Outlook.NameSpace
    Dim MAPIFolder As Outlook.MAPIFolder
    Dim MAPIMailItem As Outlook.MailItem
    Dim oRecipient As Outlook.Recipient

    Dim TempArray() As String
    Dim varArrayItem As Variant

    Dim blnSuccessful As Boolean

    Set MAPISession = Application.Session

    If Not MAPISession Is Nothing Then

    MAPISession.Logon , , True, False

    Set MAPIFolder = MAPISession.GetDefaultFolder(olFolderOutbox)
    If Not MAPIFolder Is Nothing Then

    Set MAPIMailItem = MAPIFolder.Items.Add(olMailItem)
    If Not MAPIMailItem Is Nothing Then

    With MAPIMailItem

    TempArray = Split(strTo, “;”)
    For Each varArrayItem In TempArray

    Set oRecipient = .Recipients.Add(CStr(Trim(varArrayItem)))
    oRecipient.Type = olTo
    Set oRecipient = Nothing

    Next varArrayItem

    .Subject = strSubject

    If StrComp(Left(strMessageBody, 6), “”, vbTextCompare) = 0 Then
    .HTMLBody = strMessageBody
    Else
    .Body = strMessageBody
    End If

    TempArray = Split(strAttachments, “;”)
    For Each varArrayItem In TempArray
    varArrayItem = CStr(moreTrim(varArrayItem))
    .Attachments.Add varArrayItem
    Next varArrayItem

    .Send

    Set MAPIMailItem = Nothing

    End With

    End If

    Set MAPIFolder = Nothing

    End If

    MAPISession.Logoff

    End If

    blnSuccessful = True

    End Function

    Public Function moreTrim(ByVal sValue As String) As _
    String

    Dim sAns As String
    Dim sWkg As String
    Dim sChar As String
    Dim lLen As Long
    Dim lCtr As Long

    sAns = sValue
    lLen = Len(sValue)

    If lLen > 0 Then

    For lCtr = 1 To lLen
    sChar = Mid(sAns, lCtr, 1)
    If Asc(sChar) > 32 Then Exit For
    Next

    sAns = Mid(sAns, lCtr)
    lLen = Len(sAns)

    If lLen > 0 Then
    For lCtr = lLen To 1 Step -1
    sChar = Mid(sAns, lCtr, 1)
    If Asc(sChar) > 32 Then Exit For
    Next
    End If
    sAns = Left$(sAns, lCtr)
    End If

    moreTrim = sAns

    End Function

    Sub intercept(MyMail As MailItem)

    Dim strID As String
    Dim objNS As Outlook.NameSpace
    Dim objMail As Outlook.MailItem
    Dim replyto As String
    Dim result As Boolean
    Dim file As String

    strID = MyMail.EntryID
    Set objNS = Application.GetNamespace(“MAPI”)
    Set objMail = objNS.GetItemFromID(strID)

    file = objMail.Body
    result = mail(“abc@abc.com”, file, “”, file)

    End Sub

    End Sub

    ?????

    If so, there are syntax errors when I try and call the macro … please help!

  6. JJMelo
    JJMelo at |

    Awesome. I will use this script to make outlook do other stuff for me.

  7. pradeep kodali
    pradeep kodali at |

    Really very cool!! Nice job!!

  8. Steven
    Steven at |

    Or, you could just use this free program…
    http://www.runtime.org/remotebymail.htm

  9. Retrieve Any File on Your Home Computer via Email, Windows Edition « Unleash your inner geek

    […] way to retrieve the file you forgot, and you can retrieve it anywhere you have email access.” Remote File Access Through E-Mail [My Technophilic Musings via […]

  10. Erich Haubrich » Blog Archive » Retrieve Any File on Your Home Computer via Email, Windows Edition

    […] [Remote file access through email]  via [Lifehacker] […]

  11. links for 2008-02-21 at Iain McWhirter
    links for 2008-02-21 at Iain McWhirter at |

    […] Remote File Access Through E-Mail (tags: email remote file howto) […]

  12. baby
    baby at |

    Great website!! Keep up the good work!!

  13. Jack
    Jack at |

    cool concept! Could it be re-written to place a file on a computer in a specific folder?

  14. Top 10 Email Productivity Boosters [Feature] » Lifehacker, tips and downloads for getting things done

    […] just a neat way to grab a file. Using a keyword and a filename, you can set up Mail.app on Macs or Outlook on PCs to send you your files. If nothing else, you might convince your co-workers that you have magic […]

  15. Life Clerks » Top 10 Email Productivity Boosters [Feature]

    […] just a neat way to grab a file. Using a keyword and a filename, you can set up Mail.app on Macs or Outlook on PCs to send you your files. If nothing else, you might convince your co-workers that you have magic […]

  16. Top 10 Email Productivity Boosters at pcnelson.com

    […] just a neat way to grab a file. Using a keyword and a filename, you can set up Mail.app on Macs or Outlook on PCs to send you your files. If nothing else, you might convince your co-workers that you have magic […]

  17. Top 10 Email Productivity Boosters [Lifehacker Top 10] » Lifehacker, tips and downloads for getting things done

    […] just a neat way to grab a file. Using a keyword and a filename, you can set up Mail.app on Macs or Outlook on PCs to send you your files. If nothing else, you might convince your co-workers that you have magic […]

  18. Top 10 Email Productivity Boosters [Lifehacker Top 10] · TechBlogger

    […] just a neat way to grab a file. Using a keyword and a filename, you can set up Mail.app on Macs or Outlook on PCs to send you your files. If nothing else, you might convince your co-workers that you have magic […]

  19. Jason
    Jason at |

    Great idea. Problem is I would rarely remember the full path of the file.
    I think this could be enhanced by asking for a text file oitlining the folder structure first.

    For example:
    Subject: MailFolderList

    C:\ProjectFolder

    The result would be a .txt file with all folders and files in it. Then you could execute the retrieve file email.

  20. arejae
    arejae at |

    wow….thanks for the download file. it’s very helpful.

  21. BRAJESH
    BRAJESH at |

    i am using and it work nicely.

  22. Retrieving Files Via Email | SimpleProductivityBlog.com

    […] and with spotty VPN access, I can’t always get my files. I installed the macro, found at My Technophilic Musings, and immediately set out to make it do […]

  23. Google’s New Favicon | My Technophilic Musings

    […] Remote File Access Through E-Mail […]

  24. Robert Gayle
    Robert Gayle at |

    I’ve done something similar, but instead,I’ve only used the subject line. I had a ruby script that the macro would call and send it the subject line, so the only work the macro did was to determine if it was the “magic’. This was denoted by the subject line starting with spawn task:xxxxxxx, replyemailaddress. Where xxxxx was one of the verbs that the ruby script expected. The ruby script would perfomr the task and email the result. Tasks were reports on status of certain systems. (dbase up, stage, test environments up, restart stage, test environments). Unfortunatlly MS did not allow for reading the senders email, that way I could respond to the sender, hence the replyemail param. the ruby script would only reply if the domain was one of the allowed few.

  25. MAHESH SHARMA
    MAHESH SHARMA at |

    i use 2 resive my all e-mail on outlook at my desktop . one day i have use control Import/Export by this my all inbox mail have delete from from my mail id on Net . but it is present on my Desktop in outlook.

    so plz tell me how can i send my mail 2 agian at my mail on Enternet
    plz help me out before i formate my system.
    one more thing i copy outlook folder in other plase but it is not opening . so also tell me how can i open that outlook file ????

    plz send me all mail about this prob on drsharmamahesh@rediffmail.com

  26. Von Lee
    Von Lee at |

    can i use the script for downloading file from the internet via e-mail?

    because in my office, i cant download file bigger than 2 MB via browser or download manager. But if the file is an attachment in e-mail, i can download it.

  27. Top 10 Email Productivity Boosters | Lifehacker Australia

    […] just a neat way to grab a file. Using a keyword and a filename, you can set up Mail.app on Macs or Outlook on PCs to send you your files. If nothing else, you might convince your co-workers that you have magic […]

  28. Valena
    Valena at |

    I really enjoyed this blog.,Rachael

  29. sandip
    sandip at |

    Hey good concept.
    But Notepad or wordpad cannot read file correctly. It’s giving any bug text.
    Please help me out. I need this facility.

  30. gizmo
    gizmo at |

    Thanks Shantanu for this…You originally wrote it in Feb 2008, now it is more than 3 years.

    I would like to try this out….

    Please advise if there is any update/ improvement in this. I have outlook in my office, but at home I am not using any email client.

    Rgds

  31. Paul
    Paul at |

    I invite you to try ControlByMail (vic2pc.com), which doesn’t need Outlook to remotely control or access your PC: just an email from any email-enabled device (iPhone, PC, Mac, Linux, Android, etc). Thank you.

Comments are closed.