Search results for query: *

Oops... The If statement should read: If FD.Show = True Then For Each vrtSelectedItem In FD.SelectedItems .Attachments.Add vrtSelectedItem Next End If

Thanks everyone for all the help. I figured out the code and it looks like this: Private Sub Completion_Dt_AfterUpdate() Dim oLook As Object Dim oMail As Object Dim FD As Object Dim vrtSelectedItem As Variant Set oLook = CreateObject("Outlook.Application") Set oMail =...

Thanks for the help... but I've been getting an error when I Dim As FileDialog. The error highlights the 'FD As Dialogue' line and says "User-defined Type not defined." My code below: Private Sub Scanned_Dt_AfterUpdate() Dim oLook As Object Dim oMail As Object Dim FD As FileDialog...

I'm not sure how to use that. Where would I add the code?

Below I have the VBA to automatically open an email after update on a field. Instead of attaching a specific attachment (in this case "C:\Folder1\Folder2\File.xlsx") I would like to automatically open the insert file browser in Outlook for that specific email so that the user can select one or...