Search results

Unfortunately there aren't just folders. They sit on a specific server and normal access is through a specific projectwise application that requires users to login etc. It seems from what i've read online their is a API that should allow access via Outlook although couldn't find much...

Does anyone have any experience integrating Outlook with Projectwise? Specifically I'm looking for a way to save emails directly from Outlook in MSG format to a Projectwise folder

Michael, you are an absolute star. I have been searching for ages and couldn't find anything. Your suggestion works perfectly. Thank you so much

When I say open, I mean display the CHM file i.e. you click a button and the help file is displayed

Is there a way to open a CHM file from within an Outlook userform? I've tried searching on Google but can't seem to find anything that works. Thanks for your help

I have an Outlook userform that displays data retrieved from an Excel spreadsheet. The userform uses the following code to pull and display the data: Private Sub UserForm_Initialize() Me.Top = Application.ActiveWindow.Top Me.Left = Application.ActiveWindow.Left Dim xlApp As Object Dim...

Sorted. I had to add xl.Visible = True after the line of code Set xls = xl.Workbooks.Open(strFullPathAndFileName)

I am trying to open an Excel spreadsheet from within Outlook using the code below. It works perfectly if Excel is already running. If Excel is not already open it seems to open Excel (as it appears in task manager) but doesn't open the spreadsheet. Any ideas? Dim xl As Object Dim xls As...

Diane, yes that line of code was the problem. Can't believe I didn't spot it. Anyway changing the block of code that started with that line to the following , solved the problem. Thanks very much If UserForm4.TextBox3.Value = "NO" Then myItem.Subject = "[Filed" & " " & Date & "]" & " " &...

I am using Items_ItemAdd(byVal Item As Object) to monitor the sent items folder and when a new item is added a userform loads. The userform has several buttons each with their own macro attached. One of the macros selects the item that has been added to the sent items folder and then saves it in...

Is it possible to create a splash screen that is displayed when Outlook 2013 starts up? I don't want to replace the application splash screen but would like my own to be displayed. Essentially I want to be able to display a userform when outlook starts and the splashscreen would then close after...

I'm fully sorted by using the sort function, sorting by ascending senton date and then selecting the first item

I have solved this issue. The olFolderSentItems should actually be olFolderSentMail. However I still have the problem of selecting the item that was added to the sent items folder and then running a macro on this item

Diane, I have pasted the code above into ThisOutlookSession and when I startup outlook I get a runtime error and the debugger highlights the following line of code: Set Items = Ns.GetDefaultFolder(olFolderSentItems).Items Any thoughts?

Diane, the problem is I am intercepting the process by opening a userform when the item hits the sent items and I then have different macros to run from buttons on the userform so I need these macros to be ale to be applied to the items that's hit the sent items folder

OK so I use this code to open my userform, and then the relevant button can use the SaveSent2_test() code above, but I will need to amend that to select the item that has been added to the sent item folder. How do I do that? I alsi have some code that checks for missing attachments etc that is...

Niton, Unfortunately this doesn't work. If I try and use your code when sending a new email, it works to an extent but actually saves the message as an unsent message in MSG format. What I really need is to save the sent message in MSG format. Also when I try and forward or reply to an email...

I use the same code on another userform to save messages that are selected in a folder although I have changed the macro and sub names in the other code. If I REM those lines of code out then nothing happens. I get no errors but the message isn't sent or saved. The userform stays open so it...

I've just tried it again and whilst the user form loads when I click the button to send and save the MSG which runs the code above, it is the original message that is being saved

The organisation I work for has a requirement to save incoming and outgoing emails in MSG format in a standard filenaming format to different locations on a server (different projects have different locations on server). As I can received hundreds of emails per day I am trying to develop some...