lotus notes

  1. L

    How do I count the emails sent by my employees on Lotus Notes with VBA?

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

    VBA Lotus Notes count sent emails by user

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

    How do I forward mail in Lotus Notes using VBA?

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

    Get table from lotus note email to excel cell

    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 =...
  5. Mikec1012

    Macro & Lotus Notes

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

    VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

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

    VBA Macro to send email from Excel Crashing

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

    Macro Stopped Working (Worked fine for months)

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

    VBA to Lotus Notes: add attachment IN body

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

    Lotus Notus send email with VBA - problem with version 9

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

    VBA Lotus Notes : Issue with Sender in Sent Item inbox

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

    VBA - Identify name of the file

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

    Need help using VBA to email attachments through Lotus Notes 9.0

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

    Send the active sheet or Range of cells as mail

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

    Command button - Lotus notes email

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

    Automate emails (lotus notes) from excel - Basics

    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?
  17. F

    Email cell contents via Lotus Notes

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

    VBA Hyperlink in Lotus Notes Not Working

    This forum is brilliant and has saved me many times, but here's an odd one I cant answer. The code below sends a hyperlink of a pdf to Notes. The code works fine, including an active link in the email, except when the link is clicked and IE opens, it only navigates to my homepage. Yet, when I go...
  19. A

    Send lotus reminder based on date table in excel

    Dear All Excel Experts...I need your immediate help...its been years together I am not getting any help on Lotus Calendar and excel integration.. I am working on a MOM. MOM have certain items need to be completed by certain dates. Many of the times I miss the action item deadline. I wish to...
  20. G

    ACCESS VBA code to send email's on Lotus 8.5

    Hi to all; I've this code bellow is to send email's field in access but it only send to the first email only; rst![Email] --> test@test.com,test@test2.com It can be 1, 2 or more; ---/--- Private Sub Command43_Click() Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 Dim rst...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top