lotus

Hi, Can anyone please help me with the VBA code to download or save emails from Lotus notes to local drive ie in desktop. Thank you so much in advance.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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