Search results

Thank you I have been able to write part of the code up to now Kesh

Thank you for your reply. Let me clarify. I need to copy data from column D only. For some rows the cells in Column D are blank. I do not need those cells. I need only the cells that contain a value. Secondly Sheet 1 is where I am preparing a report with several other columns. The data...

I have a sheet which contains several columns. The sheet displays blocks of data with a total at the end of each block. I want to copy the cells from the sheet (named Citi) to Sheet1 from column D but only from those cells with a value. The value occurs several times but I need to copy it once...

Thank you. I will try this and get back to you.

I have written a VBA code with the following line row = Application.WorksheetFunction.Match(ComboBox1.Value, Sheets("Agent Summary Report").Range("A1:A10000"), 0) it returns the value of the row after value from a combobox (a name) matches a list in another worksheet. If it does not match...

Thank you Trevor I have access to control panel and I know how to use the task scheduler. What I need specifically is the code for sending e-mails on excel automatically. I will take care of starting excel opening the workbook and closing it Kesh

Hi Trevor i have looked at the website. It shows how to write the VBA code and assign it to a button. I would like to the e-mail to be sent automatically every day at 8:00 a.m. Any thoughts? Thank you Kesh

Thank you Trevor. I will look into this

Excel 2007. Hi I want to send an e-mail automatically from Excel. Can anybody please help me? Thank you Kesh

Thank you jatsold3 Thank you McSwifty Hi McSwifty, Could you please elaborate on what the FE db does? Thank you Kesh

Ms-Access 2007 I have built up a report and I want to send it to users as attachment to an e-mail. The e-mail is to be sent automatically at 8:00 a.m daily on weekdays, I have written the following code which does open the e-mail and attaches the report but waits to be manually sent: Can...

Thank you Trevor

Hi, My name is Kesh. I am using the code you posted to send e-mail: Dim sSubject As String Dim sToName As String Dim sDocName As String sDocName = "rptnewsletterdatabase" sSubject = "New Record Added for " & Me.ReferenceControlName sToName = "you@yourdomain.com" DoCmd.RunCommand...

Thank you Trevor. I just worked out a way to do it on Ms Access using DateDiff But to answer your question though. Yes stale is for old, the only criteria is records older than 72 hours. The spreadsheet can be attached as an excel document or .pdf. "Call Scheduled for" is a cell Thank you...

Thank you Trevor. A filter will not tell you if it is 72 hours stale because the date and time is in 1 cell in the format DD/MM/YYYY HH:MM:SS. In my case it is required to compare the value for "Call Scheduled for" with Today's date and time and find the diffrence on a daily basis. So...

I need to select records from an Excel worksheet which has several columns but with a certain criteria. There is a column called "Call Scheduled for" which contains data and time. So if I run a macro every morning at 8:00 a.m. the records selected from the worksheet will be those which are...

Never mind Paul. Now the report is working. It's uncanny. Thank you very much for your help

I have uploaded the files again - there are 10 files in all

Hi Paul, I have uploaded the db as split zip files, with name "CS Performance Scorecard" It should be ok Thank you again for your precious help

Thank you Paul Yes I will try to upload the DB. But I cannot see any way to upload it. I did upload a screen print in a previous post though I will look into this again