Search results

Isn't it really annoying when someone starts helping you.... and once they reach a point where they can't help anymore, instead of saying so they just lead you up the garden path!

It's failing on the following line: Set AttachME = Maildb.CreateRichTextItem("file") I'm just wondering whether it's anything to do with sending from an email account other than my default, as my original code to attach the file and send it worked.

I've tried this but am still getting the message ' run time error 438. object doesn't support this property or method' Additionally the email it creates is from the default author, and not the one defined as MailDb.

Chenn, Thanks for the reply. I wonder if you can elaborate as I'm totally new to Lotus script. How exactly do I create the text item of a "file" in Lotus and then fill the item with the file I'm trying to attach. Cheers.

Forgive me if I'm being a bit dim, but isn't that the code that I'm running? My problem is that I'm sending the mail from a mail account other than the default, and am using the COMPOSEDOCUMENT method. The code to attach the file does not work in this case.

I'm running the following code to send an email via Lotus notes. I'm specifying which email account to send it from which works fine. The problem I've got is when I'm attempting to attach a file to the mail I get the message 'Run time error 438. Object doesn't support this property or method...

Please ignore this. I've found the solution in the following thread: www.access-programmers.co.uk/forums/showthread.php?s=&threadid=39422&highlight=lotus+account I guess I should've searched a bit harder before I posted my question. Thanks.

I have an application which emails reports out through Lotus Notes which on the whole works fine. My problem is that I want the author of each email to be different to the current users username and maildbname. I've tried overriding this in the code but it still seems to set the sender as the...

Hello, I have some VBA code that is starting an instance of Excel, and running an excel macro against a txt file. It works fine, except as part of the macro I'm merging multiple cells in the same row together. Each time I attempt to do this I get an Excel warning message stating that only the...

Thanks for the suggestion Patrick. I tried it but still got the same problem. One thing that may be worth mentioning is that I've included the Excel 8.0 object library references, but when I create the first spreadsheet I get a messsage from excel saying that the spreadsheet was created using a...

I have the following module which runs an excel macro and mails the resulting spreadsheet. *************************************************** *************************************************** Public Function SendNotesMail(strSendTo As String, strBody As String, strSubject As String) 'This...

EMP, You're absolutely right! Sorry for being so dim.... I couldn't see the error for looking! Thanks.

I'm running the following code to insert a record into a table: db.Execute "INSERT INTO email_this " _ & "(f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17,f18,f19,f20,f21) VALUES " _ & "('" & t_f1 & "', '" & t_f2 & "', '" & t_f3 & "', '" & t_f4 & "', '" & t_f5 & "'," _ & "('" & t_f6...

I have a form with a text box that I want to spell check on the after update event using DoCmd.RunCommand acCmdSpelling When the spell check runs it causes Access to hang, and I have to restart the application. Anyone got any idea why this is happenning or what I' doing wrong.

Fizzio, Unfortunately the recordset won't be empty as the store_number, week and stock data fields will always be populated. I've never come accross DLOOKUP, any pointers? Thanks.

Can anyone help? I'm running the following code: ' Find the email address appropriate to the current stock tracker record strsql = "SELECT import_stock_data.store_number, import_stock_data.week, " _ & "import_stock_data.stock_data, lookup.email_address " _ & "FROM lookup INNER JOIN...

AnnePep.... thanks, you're a god damn genius. Yes I do have a table called Null so you're absolutely right. Thanks again.

I'm trying to create an excel spreadsheet using the following code: Dim db As DAO.Database Dim rs As DAO.Recordset Dim strsql5 As String Dim objxl As Excel.Application Dim objxlwrkbk As Excel.Workbook Dim objxlwrksht As Excel.Worksheet DoCmd.OutputTo acOutputTable, "null", acFormatXLS...

Thanks... I'll give it a whirl. Sorry about the dyslexia!

Thanks Mike.... sounds great, but just one question. Any ideas on how I would write this into my spreadsheet, as a present I'm just creating my spreadsheet using: DoCmd.OutputTo acOutputTable, "email_this", acFormatXLS, "C:\filename.xls", False The table "email_this" just contains rows of...