Search results for query: *

Hi, I have the following code from VBA that loops through all documents in a mail database and extracts all the attachments from them. The only problem is I have to make sure that I do not detacth any files that have a certain email address. Does anybody know how I can extract the email...

Hi, I am a real Newbie to developing with Notes an would really love someones help. I have been doing some VBA script in Access to access a Notes Mail Databaseloop through them and check to see if they have an attachments and then detatch them. I have got as far as to open the database, loop...

Automated Detacthments From Notes via VBA Hi, I am a real Newbie to developing with Notes an would really love someones help. I have been doing some VBA script in Access to access a Notes Mail Databaseloop through them and check to see if they have an attachments and then detatch them. I...

Hi, thanks for the advice I managed to solve the problem with the following two lines of code... Set doc = vw.GetDocumentByKey(strNotesID) doc.Remove (True) Cheers, Hayden

Hi, I have an Access DBase that records all our European shipments that exports the data to a Notes DBase that has a Web application built ontot hat. Currenty we have to export the data from Access, delete the current Notes data before replacing it with the new output. But I have replaced...

Hi, I have an Access DBase that records all our European shipments that exports the data to a Notes DBase that has a Web application built ontot hat. Currenty we have to export the data from Access, delete the current Notes data before replacing it with the new output. But I have replaced...

Hi, I have some code that opens up our Electronic Advice Notes (These are prettyr much excel spreadsheets our suppliers edit and return) but I am having a few problems selecting different WorkSheets. The suppliers will group 5 sheets into one workbok and rename them - Although the spreadsheets...

Thanx soooooo much, you are a God!!!! cheers, Hayden

Hi, I have some code written that creates and Excel Application, copies 3 recordsets (Each is a seperate report) into 3 different worksheets. The code works fine the first time i run it but if I try to run the code again without closing the database i get a error message "91 - Object...

Hi, I have some code written that creates and Excel Application, copies 3 recordsets (Each is a seperate report) into 3 different worksheets. The code works fine the first time i run it but if I try to run the code again without closing the database i get a error message "91 - Object...

Hi, I have written some code that takes a template spreadsheet, populates it with required data and then automatically emails it to the Supplier. The problem I have is that if the user has another excel spreadsheet open it always uses this as the template and not the file. What I would like...

Hi, I have a database that exports a recordset into a spreadsheet and I need to lock the cells that I have copied the recordset into. I can lock the cells but I don't know how I select the range of the copied recordset to lock the cells. The number of records that is pasted into the...

Hi, I have written some code that opend up a template spreadsheet file and then sends data to the spreadsheet for every consignment within a recordset. I intend to send this spreadsheet/advice note out to the relevant suppliers (This has not been added to the code example below) for them to...

Thanks Cheerio, that worked great Hayden

Hi, I have some code written that creates an excel application, formats the page and copies in a recordset from my db which works fine. But now I want to add additional recordset at the bottom of the spreadsheet but I do not know how to do the xlDown function in Access VBA. As the recorsets I...

Hi, I am trying to create a new routine that creates a new excel workbook and then copies three tables into three different worksheets in the same workbook. The only problem is that I cannot change to other worksheets. I have created the code to open and create the workbook and copy the data...

Hi, i am trying to set up some rules for incoming mails on my lotus notes (Release 5.08) but I cannot find the Rules Folder that the Notes Help describes. I am using a company specific template for Notes which has changes some of the options, views and menus. Does anybody have any idea how I...

Hi, i am trying to set up some rules for incoming mails on my lotus notes (Release 5.08) but I cannot find the Rules Folder that the Notes Help describes. I am using a company specific template for Notes which has changes some of the options, views and menus. Does anybody have any idea how I...

Hi, I have some code that creates emails with attachments via lotus notes but I cannot get it to confirm a delivery reciept. does anybody have any help on how I can get this to work? Here is the code i am using... Public Sub SendNotesMail(Subject As String, Attachment As String, Recipient...

Hi, thanks for the code, but it is giving me a compile error "Method or data member not found" on the .CreateField("Item") part. Is there anyththing I can change in the references. Many Thanks, Hayden