Search results

Hi, I'am using below code to send automated mail by copying range from excel. But image (excel range) which is getting copied from excel range & pasted in Lotus notes new document is aligned to left. I want to make this "Center". any help on this..!!! Public Function SendEMail() Dim thisWB...

Hi, I've created one macro to send e-mails from excel automatically in picture format. (I have one Pre-defined format of e-mail in excel sheet which is getting copied & paste in lotus notes in image format, every-time when macro runs). Problem: I'am not able to send e-mail. I know fault is...

Hi, I've been able to send e-mails using lotus notes after lot of macro munching in excel but without attachment. I'am using below code to add attachment. Please somebody tell me error in this code. attachment1 = "D:\Agent Data Sheets\" & Sheet2.Range("A3") & ".XLS" In this code i want to add...

Hi, I'am using Excel 2007. I have created one macro to extract data on the basis of one field inclusive of Pivotsummary. I want to save Output excel file in .xls format instead of .xlsx Need support to check where I'am lacking. Using below code I'am able to extract data with pivot summary &...

Hi, I'am using excel 2007 & i want to send e-mails to different users using lotus notes 8.5 along with some summary. Till now I'am succeed to send e-mails to different users by clicking command button using below code. Problem: I'am extracting my base data from MS access using data connection...

Hi, I'am using MS-access 2007 to create record-set. Problem is that I'am using lot of Dlookup's to extract data which is increasing time to extract details on VBA form. I want to use record-set because I've heard from someone that it will reduce cycle time to extract record details drastically...

Hi, I'am using below code to extract fields from my split database table to VBA form. But getting below error. Error #: 3061 Too Few Parameters. Expected 2 I have checked through Debug.Print help. It is giving error at "STRSQL" text which is highlighted in blue color. I'am quite new in VBA...

Hi, I'am quite new in VBA programming & doesn't know anything about Recordset etc. But have searched on google that Recordset & seek could help in making code much faster than dlookup's. I'am really keen to learn how this Recordset & seek works..:p I have split database (in common shared...

Hi, I'am using Access 2007. I'am looking for some kind of loop through i can assign cases in my database table from VBA form drop down users list automatically one after one where assignment is not done till yet in database table. What i mean with One after one is, I have 3 name in drop down...

Hi, I want to append Current_Date_Time before customer_comment field But not able to do so after lot of efforts. e.g. customer remark is : - I don't want to Pay Call end time is :- 6/28/2011 8:54:34 PM Final output should get saved in Customer Comment column is: - 6/28/2011 8:54:34 PM ---I...

Hi, I am using "SEP Date Control" & "SEP Time Control" to insert customer suitable date & time in my database (Telecalling_database). These entries are getting done by some tele-callers through Access VBA form. Please help me to understand what is wrong in below code or is there something...

Hi, I'am using below update command to update existing record on the basis of primary key (Instrument_Number) but getting below error "Syntax Error (Missing Operator). Can anyone help me to find out the error. DoCmd.RunSQL "Update Telecalling_database set Calling_end_Date_time = " &...

Hi, I am using MS office 2007. I'am in process of making one automated VBA user form for multiple users (5) using split database for smooth data entry in common shared drive. Problem: I want to populate data from shared access table to VBA form of each user by name & date automatically one...