View Single Post
  #1  
Old January 2nd 13, 09:45 PM
BrentLaftin BrentLaftin is offline
Junior Member
 
First recorded activity at Outlookbanter: Jan 2013
Posts: 2
Default VB question (Reply, Select All, Copy, and close email)

Hi,

I'm trying to code Outlook to Reply, Select All, Copy, then close an email. I can make the below code work perfectly if I don't have the Reply code in the script, when I add the Reply code it stops working.

I'm using this code to quickly copy all contents of a selected email so I can paste into a note record in my work system. I was also hoping to add a line of dashes "------------------------------" between each individual email (header) but that's way above my head.

Any help would be greatly appreciated, here's the code I'm struggling with:

Sub CopyAll_and_openSite()
Dim objApp
Dim objInsp
Dim colCB
Dim objCBB
On Error Resume Next

Set objApp = GetObject("", "Outlook.Application")
If objApp Is Nothing Then
Set objApp = Application.CreateObject("Outlook.Application")
End If
Set objInsp = objApp.ActiveInspector
If TypeName(objInsp) = "Nothing" Then
MsgBox "No inspector window found"
Exit Sub
Else
Set colCB = objInsp.CommandBars

Set objCBB = colCB.FindControl(, 354) ' Reply
objCBB.Execute

Set objCBB = colCB.FindControl(, 3634) ' clear clipboard
objCBB.Execute

Set objCBB = colCB.FindControl(, 756) ' select all
objCBB.Execute

Set objCBB = colCB.FindControl(, 19) ' copy
objCBB.Execute

Set objCBB = colCB.FindControl(, 2011) ' Close email
objCBB.Execute

End If

Set objCBB = Nothing
Set colCB = Nothing
Set objInsp = Nothing
End Sub
Ads