lotus notes

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

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

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

Hello, Is there a way to get hyperlinks from Lotus Notes mail body and save it in a cell in Excel using VBA? I am trying to run a macro which will open the specific mail, go through the mail body and find and save the hyperlink present in the mail. Or if it is possible to get specific words...

Hello. Is there any way to programatically (by VBA) add an attachment to an invitation meeting in Lotus Notes? A lot of google-ing did not clearly reveal the method. Below is my code which blocks at line '*** Call objNotesRichTextItem.EmbedObject(1454, "", Attachment1, "") *** Sub...

Hello I'm trying to find code, involving pressing a button within excel will launch and email to the same recipient every time, but the subject of the email will always be based off of a certain cell (C5). I know how to create a button and assign it a macro, I just need help getting the code...

I am working on a macro to send emails from VBA. Some of the strings for all of the emails address are greater than 255 characters. I really dont want to have to make a macro that splits them up into the SendTo, CopyTo, and BlindCopyTo fields as some could be longer than 765 characters.

I have an Excel sheet that I use as a mailing automatism for reports. As it currently is it attaches an actual copy of the excel workbook to the email and send them out. The mailer contains several different people, and they get different report each day. Due to the size of some of the files...

Search syntax in vba for lotus notes documents in view. Urgent Need help with vba code. please have look below on the code. thanks Private Sub CommandButton1_Click() Dim nSess As Object 'NotesSession Dim sPwd As String Dim strCnxn As String Dim strSQL As String Dim db As Object Dim iviews As...

So I stumbled across this thread yesterday while searching for ways to automatically send emails using Lotus Notes. The first solution posted by John Davis is almost perfect for my needs, however there is one thing that is still giving me a problem; my signature will not attach. On Lotus Notes...

Hello, I have an excel document that I would like to insert a Submit button that will send out the Excel document to a number of people. My thought would be to click submit in Excel and then it will attach the file to a Lotus Notes email with about 5 peoples name automatically appearing in the...

I stole the following off of another post. I've added just a bit more, but I need to get it to attach a file that I would like to spell out in the call statement if at all possible. I cannot find the correct wording. :confused: Thanks! Laura Call SendEMail(Array("Laura.Ford@fotlinc.com"...

I have the following macro that works fine except for 1 exception - it does not enter any text as the body of the message. How can I edit this code so it includes a message for the body of the email? Sub EmailRDReport() 'Working in Excel 2010 with Lotus Notes Dim wb As Workbook Dim I...

Hi All, I managed to get a code that will automate my email preparation. The code gets recipients, subject and the body of the mail from the active worksheet and it works perfectly for the recipients and subject, not so much for the body. Say the mail body is c1, c2, c3, c4, c5, c6, c7 and...

I couldn't find anything on this. I have about 20 reports emailed to me throughout the night. Each come in separate emails and go to a designated folder based on mail rules I have set up in LN. Each day, I have to go into each email and save the reports to my hard drive. Then go through and...

I found Nate Oliver's code (below) and tried it to send an email, including attaching the active workbook through the workbook using Lotus Notes. It works as advertised, except the workbook doesn't attach. The recipients, subject and body are all fine. I noticed the original post was from 2006...

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

I copied (and only slightly edited) the below code from another website (credit due).. It works fine if I don't have an attachment, but with an attachment... I'm getting a "file not found" error at the line indicated in bold red below.. the file certainly is where I've said it is, so I...

I've posted this in other forums, with NO reponses, so I apologize for cross-posting... I'm using Excel2007 and Lotus Notes 6.5 (Lotus Notes Designer is no help either!) Many years ago, a developer for several of our Lotus Notes databases decided to "Protect" some Authorization data by...

Newbie alert! I have read the forum, found and modified code to use Excel to send an email via Lotus Notes. I have the email working and really enjoy the power of VB. I see a class in the near future. I have a spreadsheet with Comany Name in column A and email address in column B. How do I...