Need help wih Lotus Notes automation

  • Thread starter Nick via AccessMonster.com
  • Start date
N

Nick via AccessMonster.com

Hello all,

I need some help with my Lotus Notes automation, specifically the Automatic
Signature; this seems like it should be a fairly simple question but I can
find no documentation about this particular area.

I am using VBA to create an e-mail through Lotus Notes, and I had it working
fine on my machine (No automatic signature). I moved the application to
another machine, and the guy on the other machine has a signature
automatically added to all e-mails. The problem is that the signature is at
the beginning of the e-mail; the body text of the e-mail ends up looking like:


(Insert signature here)New kits have been added...

Is there a fix/workaround to this? Like a way to turn off the signature and
append it through code, or a way to detect the sig and cut and paste it
through code? Any help/guidance you all could give would be great.

Thanks very much in advance,
Nick
 
K

Kevin K. Sullivan

Nick,

Unfortunately, you did not show the VBA code you use, so I'm guessing in
the dark. The way Notes works is particular to your mail template, so I
won't try to guess about it. I'm just wondering if you have the
equivalent of the following happening.

-you create a NOTESDOCUMENT
-the mail template places the sig text into the Body field
-you append your text to the end of the body

The solution in this case is to:
-you create a NOTESDOCUMENT
-the mail template places the sig text into the Body field
-save the existing Body text into a string variable, strExistingBody
-set Body field to strYourText & strExistingBody

Again, post your VBA code if you want more specific help.

HTH,

Kevin
 
N

Nick via AccessMonster.com

Kevin,

Thanks for the reply. Below is some of my code... I don't know how much you
need and I have to go to a meeting in a minute so I will give you the
problematic area. Your suggestion makes sense... I am just having trouble
implementing it.

Set MailDoc = maildb.CREATEDOCUMENT

MailDoc.Form = "Memo"
MailDoc.SIGNONSEND = False 'Does
not help
MailDoc.Subject = Subject

MailDoc.SIGNATURE = ""
'Does not help
MailDoc.Body = ""
'Will not clear out the signature
MailDoc.Body = strBodyText

I guess my question is - should I be using something other than MailDoc.Body?
I wondered if .Body might not include the signature, if it would be
controlled by another area... I'm sorry if this makes no sense, I am kind of
stumbling along trying to understand the signature aspect.

If you want the full module, please let me know and I will clean it up and
post it soon.

Thanks again for the help.

Nick
 
N

Nick via AccessMonster.com

Bleh - sorry about the bad formatting on that code. I forgot about the width
restriction

MailDoc.Form = "Memo"
MailDoc.SIGNONSEND = False 'Does not help
MailDoc.Subject = Subject

MailDoc.SIGNATURE = "" 'Does not help
MailDoc.Body = "" 'Will not clear out the signature
MailDoc.Body = strBodyText


Nick
 
K

Kevin K. Sullivan

Nick,

I'm afraid I don't know what else to advise from a VBA perspective. It
looks like you'll need to consult your Notes admin about how the sig is
added.

Kevin
 
N

Nick via AccessMonster.com

No worries - the work I'm doing is just a push to start increasing use of
Access and supported automation like Notes and Excel. I ended up just
working around the problem, I added 2 carriage return/line feeds before the
body text, so at least the text is still set apart. And the people who saw
the demonstration were impressed (which was the important part) Thanks
anyways for your help.

Nick
 
Top