notes

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 searched a lot in this forum and on the internet for my problem, but not found it yet. I'm using the following code (found on this forum) for sending a mail through Notes. This code: - attaches a file in the mail, - select/activate the Notes-Memo, - allows the user to edit the body before...

Title says it al. i need a macro that will check wether or not lotus notes is open, but I do not want it to open if it is not already Because we work wih more peoole at the same computer and they all use the same notes. so this is what i want: If notes is open then create mail (already have...

For seven years, we have been running a wonderful report-creation program frequently. It use the COM interface to automate Excel. It runs for many hours, so debugging is difficult. Ever since we moved up to Windows 7, it has started to pop up "Automation Error" boxes after several hours of...

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

Is there a way to have a shortcut to notepad or something like notepad in access so that we can write notes for the db?? Please advice

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=192 border=0><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid...

I am working on a large document where the user has the option of entering notes in many different cells on the worksheet. I would like a way pull out all the text they enter in a clean way and summarize it. When I say "clean" I mean locate only the cells they entered a note into and summarize...

I have some Excel VBA code (see fragment below) which tests the sending of an e-mail via Lotus Notes. This works fine when using a local replica of the mailfile, but not with the server mailfile: Set oNotesSession = CreateObject("Notes.NotesSession") sMailFile =...

I have sourced much code of the internet to be able to send e-mails via lotus notes from excel, although the code is likely to be very crude it seems to work fine apart from 2 small issues that i hope someone might be able to offer me guidance on. The issues are: 1: In the sent items folder, no...

Hi. I'm building a simple worksheet which will be used be people with zero expertise on Excel. Fill in cells with basic information should work ok for them: name, address, dates, etc. A column should contain comments and ideally they should be able to type in text as in notepad. I know that I...

I have been told to set up a spreadsheet to track projects although I have explained Access would be more suitable. Currently we're using 2003, but moving to 2007 soon. I will have one row per project and will need a large text field to record notes. The Comment function will be too small and...

Hello, I am trying to run this macro and I get always an "Error 1004" with the select instruction. The aim is to put a note on the same cell in the same sheet in a second (NewFile) workbook and highlight it. Could someone help me? Thanks in advance, Here is the code: Sub...

Hi, I'll give this a go as colo is unavailable. Is this possible and how would I go about doing it? Sheet1 (Calendar) has formulas in the range B14:M50 that automatically show you this months date along with the next 10 months, Col C is not used as it is a divider. Sheet2 (List) Allows...

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