lotus

  1. N

    Extracting attachment filename in lotus notes using VBA

    Hi, I am new to lotus notes automation using vba. I have a requirement wherein I have to loop through all the mails in the lotus notes DRAFTS folder and copy the filename of the attached file into an excel sheet. HELP!!! Thanks in Advance..
  2. L

    How can I convert Lotus 123 macros to Excel 2010?

    We have multiple files in Lotus 123 Version 9.6 with macros to link/update files. Any suggestions?
  3. A

    Using Lotus Notes Hyperlink, how to copy and paste data from excel into body of email

    Hi, I am using Lotus Notes. =HYPERLINK("mailto:"&H119&"?cc=tradecorp@smbcgroup.com&subject=SMBC Deposit Rates "&TEXT(Today_TradeDate,"mm.dd.yyyy")&"&body=B117:F128","SEND") When I click on the above link, the hyperlink works perfectly. It opens the email in lotus notes and everything looks...
  4. P

    Creating Multiple emails on Lotus:- Run time error '-2147023170 (800706be0':

    Hello All. This is my first post so firstly I'd just like to say thank you to you all for the help you've already given me by answer other peoples' questions over the year. I've searched for the solution to my latest problem and can't find the answer. I am trying use vba to create multiple...
  5. L

    .FINDSTRING Lotus Notes VBA

    So I'm using Excel to do some routines for me, and send an Email every mourning with the data the routine has extracted from SAP. This data includes coping 2 images, and a graph. The problem is, that when I dont have notes logged in, the macro runs smoothly, but when it is already open, the...
  6. I

    Macro to Create Lotus Notes email

    Hello, I need to create a macro that attaches my excel document as a pdf in a new Lotus Notes email and to populate the To field. I have gotten as far as creating the email and attaching the pdf, but cannot get my email address to be populated. I have no idea how to use VBA so if you have a...
  7. E

    Incompatibility of Type - Lotus rich text item VBA

    Hi , I am trying to do a macro who read my email and especially the first Table of the body of my lotus notes email . My Macro is based on the lotus documentation : Lotus Domino Designer 7 Help - LotusScript Classes A-Z and especially this example who explain how to read a table Lotus Domino...
  8. S

    query of Lotus DB - only specific records

    I'm using VBA to query a Lotus db and it works but so far I can only get it to pull all records in the specified view. Anyone have an idea how I could get this to pull only records where a specific field met certain criteria? For example... In the code below I would only want to pull records...
  9. T

    Problem generating multiple Lotus Notes emails looping, without sending

    Hi folks, i'm new to the forum and need some help regarding VBA Lotus automation. All the topics i've seen and read (also on other forums) have helped me generate my emails (without sending) but i seem to have a problem that happens sometimes. What i want : have my code loop through a file...
  10. G

    How to send email through IBM Lotus Notes 8.5 using excel 2007

    Hi, I have a worksheet, which I need to send to different areas of the business, where there are 2 businesses being handled by each area. So for Area 1 the ranges A1:B6 and H1:H6 need to be send to the email id against Area1, i.e. cell B10 (Area1@xyz.com) Mail subject: cell C10 Mail Body...
  11. L

    send mail with a body, using DialogSendMaill

    Hi, I would like to know if it's possible to send my mail by using lotus with a text body via the macro below, Application.Dialogs(xlDialogSendMail).Show _ arg1:=recipient, _ arg2:=" subject" & RegionToGet For the moment the mails I can send to each of the recipient are composed only by...
  12. J

    Closing an Edited Lotus Notes Email Using VBA

    Hey there, I created an Excel-based reporting system, which uses individual files in a shared folder. The users enter their updates in their files, and then use macros in the file to Request approval for their updates from their managers, and Release the approved data for consolidation. The...
  13. A

    How to add Prevent Copying to email from Excel to Lotus Notes

    Hi everyone, I have tried for weeks now to add the "Prevent Copying" to an email automatically generated from Excel, via VBA, to Lotus Notes. I have found code examples online, however, I couldn't get it to work on the code below. As I'm relatively new to VBA, this might be something easy, but...
  14. E

    Emailing file - How to Select a Hyperlink in the excel sheet

    <!-- / icon and title --><!-- message -->I am sending an email through lotus notes and the code that i currently have doesn't correctly pick the file. It is a pdf file that is contained in a cell by hyperlink (cell F19). there will be mupltiple hyperlinks so i want it to pick the link that is...
  15. D

    Send email if Open Issue is Overdue

    Hi all, I have an excel table which lists Customer Issues. The update depends on people remembering to access it and close out their issues. In Column A there is a sequential record number. In Column B there is the Customer name. In Column C there is the email address of the allocated...
  16. M

    Entering the Lotus Notes Password using VBA

    Hello dear all, I have an small issue with the Lotus Notes Password. Problem is: Open Lotus Notes and entering the Notes User Password using VBA After the code line: Set session = CreateObject("Notes.NotesSession") Lotus Notes opens and asks me for my Lotus Notes Access Password I need to...
  17. B

    Send WorkSHEET as Email Attachment via Excel - LOTUS Notes

    I need help putting a macro button on an individual worksheet so the user can click a big easy button and a new email will pop up in Lotus notes with the worksheet attached for them to input the address and then send the worksheet.. Any one know if I can do this or how I go about to accomplish...

Some videos you may like

This Week's Hot Topics

Top