Recent content by balvinder

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...

RESOLVED: Code not working..!!! hi, I've found solution to this problem. just added below lines in existing code & both problems resolved. NotesDoc.Doc_Category = "Business Secret" UIDOC.send UIDOC.close

Hi, I've changed my entire code for lotus notes part & finally I've been able to bring different error message close to resolution. But mails are still not going. I'am receiving below error message: "Message could not be save or send, Please select information classification" Post selecting...

would appreciate if someone can resolve this..!!!

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...

Re: How to solve this !!!___RESOLVED Been able to resolve myself... Just a little change in code & everything start functioning.. Old Code: attachment1 = "D:\Agent Data Sheets\" & Sheet2.Range("A3") & ".XLS" New Code: attachment1 = "D:\Agent Data Sheets\" & SupName & ".XLS"

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, any hint or suggestions are highly appreciated....

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...

Thanks Pbaldy.. That Worked..:)

Just wanted to know what is the error in below code. I have made it after searching on net for almost 3-4 hours. While executing this I'am getting below Error: All I'am trying to do with below code is to reduce cycle time of Dlookup's with SQL command using DAO. Please correct me if I'am...

Dear Pbaldy, Thanks for your help...I guess this is not going to help...can you please share your e-mail ID where i can send it my database so that you can check it for real errors & solutions. :)

Thanks Pbaldy.. Got some understanding about this & removed query from code & used my table name instead of "Finding_Telecalling_details". Finally Error which i was getting earlier has been changed to below: Run-time error 3265 Item not found in this collection Now error is showing at...

Dear Pbaldy... I would have attached but database size is quite heavy (300MB). Hence attaching my query SQL statement if this can help to solve the issue. SELECT Telecalling_Database.POLICY_No, Telecalling_Database.GO_CODE_Ingenium, Telecalling_Database.Modal_Premium...