Search results for query: *

Apologies for bumping my thread but I'm still looking for a solution, can anybody help?

Still brings up the same error message and highlights the "mItem.Save" line of code but thanks for responding.

With the help and refinement of several posters on this forum, I created a macro, run from the Outlook vba environment, for inserting a date and time stamp on the front end of an e-mails subject, see below for code. The purpose of the macro is to time stamp the subject of each individual email...

Thanks for responding, yes it is run in the Outlook VBA environment. The purpose of the macro is to time stamp the subject of each individual email in a folder (eg. the Inbox), so that they can be dragged and dropped into a hard drive / server / dvd folder and will then be listed in...

The problem seems to be that Outlook 2010, unlike the 2003 version, will not accept the .save command to update a message subject, hence the error message. Is anybody aware of a method of changing a message subject in VBA that is accepted by Outlook 2010?

The VB error message reads: Run-time error '-2147221239 (80040109)': The operation cannot be performed because the message has been changed.

With the help and refinement of several posters on this forum, I created a macro in Outlook for inserting a date and time stamp on the front end of an e-mails subject, see below for code. After updating to Outlook 2010 from 2003, the code which used to operate flawlessly now falls over on the...

I am using data in an Excel sheet to populate bookmarks in a Word document template, see code below for details. To this point, the macro operates perfectly but I am now struggling to place data against an additional bookmark located in the header of the Word template and would appreciate some...

Thanks combo, exactly what I was after.

I have numerous rows of data in date headed columns (See A1:D4 below for example). [tab][tab] A[tab][tab][tab]B[tab][tab][tab]C[tab][tab][tab]D[tab][tab][tab]E[tab][tab][tab]F 1 25/01[tab] 01/02[tab] 08/02[tab] 15/02[tab]<Today >Today...

Tony, I realise that you are here to help and that is all I'm asking for, not to do it for me, hence if you look at my first response to Skip, you will see that I had tried your MSProject.Project idea, aswell as .Projects. I appreciate both of you taking the time to respond.

I have already set that reference Skip.

Hi Skip, I got a compile error "User-defined type not defined" with the second line highlighted, so I changed MSProject.Document to MSProject.Project The code now terminates at the fourth line: Set aProj = appProj.Documents.Open(Filename:="C: \MS Project.mpt") with a Runtime error 438, Object...

I am trying to create a Microsoft Project document from a template, input two pieces of data gathered from an Excel spreadsheet, name the document with the same two pieces of data, save the MS Project file and exit the application. I have no idea how to open the MS Project application but based...

I use the following VBA code to incorporate the date at the beginning of each e-mail's subject in the Inbox. Is it possible to run the macro on the current folder (Inbox, Sent Items, Whatever), rather than naming a specific location? Sub AddDateToSubject() Dim mItem As Object Dim oFolder As...

Thanks for taking the time to educate me Dave, I'm using someone else's PC and never thought of that.

I am having problems attempting to insert data, gathered from an Excel 2003 SP3 workbook, into an MS Word document. The macro gathers the information satisfactorily but fails on the first line of the following code, which results in a "Compile error: User defined type not defined", with the...

I understand what you are saying Skip and will take it on board, however I have not designed this particular sheet, which is used by 15,000 users. I am merely looking for an easier method of reviewing 40 or so of them. Thanks once again for your assistance and the other posters, who have taken...

Thanks Tony, much appreciated.

Tony, byundt and GSCaupling, thanks for the responses, you have each given me something that I didn't know or hadn't thought of. Skip, the application is to check holiday (vacation) cover for staff. Each individual has the same sheet, with days numbered horizontally and months vertically. They...