lotus notes

I was wondering if there was any way I could match an email that has been replied to, with the sent view email reply. Using NotesDocuments.GetItemValue I can get all sorts of information from each individual notes document including whether the document has been replied to. Is there any...

Hello, I haven't been able to find any resource to explain to me how I can set the encoding for the .SetContentFromBytes Lotus Notes MIMEEntity method. I am trying to declare base64, in the official documentation it shows ENC_BASE64 and therefore I have this Call...

Hello, I have some code that I had thought worked fine but turns out doesn't. My code sends an email using VBA through lotus notes, it first attaches a PDF document to the email via RichText, which works and the PDF is attached. Then it uses MIME to attach a HTML to the body so I can get some...

Hello, I would like to be able to count how many emails my employees are sending out each day, I do it manually now by counting the communal sent box. Would I be able to automate this process in VBA so it counts the emails sent by each person for that day? There is lots of outlook support but...

Hello, I was wondering if anyone knew if there was a way to count how many letters are sent from the sent box by each user per day. So if John Smith sends 10 emails and they are all in the sent box, it would output into Excel something like this when the macro is run: ABC1NameAmountDate2John...

I'm very inexperienced with VBA and even more so with LotusScript, I need to find a way to extract the subject line of my lotus notes inbox then compare that subject line with email addresses and then forward the emails to those addresses. We have emails coming in with a set of unique...

hi guys, I got trouble on handling the lotus notes and internet don't have much resources on this. Here is my problem, i have a table in email look like below. <tbody> Food Drinks People Car Total 10 5 9 1 25 </tbody> And i got below code so far, but it error on Set rttab =...

Hello there! 　 I have pieced together several macros and I am almost good to go with my project. However, the macro I need help with is the actual sending the mail. The script I found, would generate a pop up and could use that to enter in an email address. However, I'd like to remove the pop up...

Hi, I found on internet a code that send a calendar entry meeting in Lotus Notes. The code works, but when I put more than one attendee, it send only to the first person in the cell. For instance, in image below on the B2 cell there is two e-mails: xx@nda.com and dd@nda.com separeted by...

Urgently need some help completing this macro I found this code on your Forum posted by John Davis (edited post by George Hart). I have edited it to suit my needs but is gives me an Active X error and fails. I have added a variant for the title. I want it to run automatically each day and go...

Hi everyone, I had a macro that would open a new lotus notes email and send a predefined, but dynamic message that I had written in excel. This was necessary because I was sending this type of email several times an hour. All of a sudden I started to get an error that read: "Run time error...

Hello ! Im beginning to get upset against my computer and I need your help! I am generating an email from Lotus Notes with VBA. Until now, I am able to create the email, send it and even include an attachment. However, I would like to have the attachment inserted into the body like: Mail Body...

I have a VBA procedure that send email with Lotus Notes. It works perfectly until an upgrade to Lotus Notes 9.0 was done. Now, whenever the macro is run there is a run-time errors. Codes: Sub SendEmailCandidat1() Dim stFileName As String Dim stRecipients As String Dim noSession As...

Hi All Good day. I have created a codes to allow sending email from Lotus Notes generic mailbox/shared mailbox through Excel. The email will also appear in the Sent Item box. However, when my colleague open the sent item , it showing their name as sender ("Sent By") Your advise and tips to...

Hi, I have following problem. Im sharing some file wich contain macro to automaticly send e-mail from Lotus Notes and I want to make my coworkers to use it. Underlined value in the script is name of the nsf file wich is contained in the same directory in their computers (its the only file in...

Hi, I'm a total novice when it comes to Excel VBA. Most of my codes have come from scouring the internet and plugging and playing until I get the desired result. I had a script that created multiple emails from a list in Excel and sent an attachment to each email within the list. This code...

Hi,# I use the following code to send mail to a person through lotus notes. But i want to send a specific page or the Range like (A1 : K50) as an attachment. Someone please help me to alter the code so that it works in the way i want it to. Public Sub CommandButton21_Click() Dim Maildb As...

Hello, my name is bharath. I am now working on a complex process planning. i have integrated data from various sources and grouped in several pivot tables according to my boss's requirement. My questions are as follows: 1. I know how to filter the Pivot table (I use slicers in my case). I want...

I have a bunch of reminder mails to send everyday. I have researched MrExcel and all responses talk about VBA. I know nothing about VBA. All I have is an excel and Lotus Notes. Can anyone help me with the basics? Is there anyway to do this without coding?

I'm trying to set up a spreadsheet for a co-worker that would let the user select an item from a drop-down, which would automatically send an email to a list of users in a separate worksheet. The email would be a review of the entries in the particular row in which they are working on, which is...