Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Adding Attachment to Outlook (2003/SP2)

    I just have a question, not a problem. When I add an attachment to a calendar item, and this is a calendar item for my own use, not one inviting others to meetings or anything, does it add an attachment or just a shortcut to the file? I am concerned about adding to many things and causing problems with memory.

    What I am doing is a daily inventory check. I have been storing the files, as a Word doc, in a directory and I came up with the idea of adding the file to the calendar for each day, just for a quick reference. However, if it clogs up the "pipes" by storing something twice, there isn't much reason to do it. I did not see an option to add a shortcut. Thanks in advance for the help.

  2. #2
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Adding Attachment to Outlook (2003/SP2)

    Thanks John. I think I will do that, it will save on some space. The interesting thing is that it doesn't like it if you use spaces in your directory name or file name, I had to go back and insert underscores. Maybe that would be a good practice anyway. Thanks for the help.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Adding Attachment to Outlook (2003/SP2)

    Don, storing files as attachments uses space in either the server or the PST, depending if you are on Exchange or a standalone machine. Not necessarily a big deal unless you are tight on space or work with huge volumes of attachments (I do). Calendar Item body text is RTF by default, so there's no hyperlink option. However, if you add the Web Toolbar to your Word Application, you can get the URL of the active document (once it is saved) from the Address box, copy it and paste it into your Calendar Appointment item. If that works for you, you can also set up your menus to show just the Address Box by customizing your Word Toolbars.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Adding Attachment to Outlook (2003/SP2)

    Or "%20" for spaces - it's a nuisance to me that the Address box doesn't do this. There may be a few other substitutions that are wise.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Adding Attachment to Outlook (2003/SP2)

    FWIW, this thread inspired me to write this Excel macro, which can be attached to a button (the Address Bar takes up a lot of toolbar space). A Word version should only require a couple of changes, possibly only changing "ActiveWorkbook" to "ActiveDocument":

    Sub ActiveWorkbookURL2ClipBoard()
    Dim objDrives As Object, objData As New DataObject
    Dim strWBName As String, strDriveName As String
    Dim intC As Integer

    If ActiveWorkbook.Saved Then
    strWBName = ActiveWorkbook.FullName
    strDriveName = Left(strWBName, 2)
    Set objDrives = CreateObject("WScript.Network").EnumNetworkDrives
    For intC = 0 To objDrives.Count - 1 Step 2
    If objDrives.Item(intC) = strDriveName Then
    strWBName = Trim(Replace(strWBName, _
    strDriveName, objDrives.Item(intC + 1), 1, -1, vbTextCompare))
    Exit For
    End If
    Next intC
    strWBName = "file://" & Replace(strWBName, " ", " ", 1, -1, vbTextCompare)
    objData.SetText strWBName
    objData.PutInClipboard
    MsgBox strWBName & vbLf & vbLf & vbTab & "is on the clipboard for pasting."
    Else
    MsgBox "Unsaved document, path unknown." & vbLf & "Save the document, then run this macro"
    End If
    Set objData = Nothing
    Set objDrives = Nothing
    End Sub
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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