Excel and Lotus Notes

Hi DW,'

I recall I answered a similar question the other day from You.

Check that thread

I can not seem to find a working example of this script, could someone pls post it again. The one that I have seems to execute, but then Lotus Notes stops responding.

Thanks,

-Brian

Instead of the whole attachment, is there a way to just append a sheet to an email and send just one sheet? For Lotus Notes.

-Brian

Hi Brian - Download the spreadsheet I've posted in this forum - works fine with Lotus Notes - have just updated the code that I've been using for some time - have not had any problems with it - Phil

Hi Phil,

The excel attachment is working fine. But can I send stationery mail in lotus notes by running a macro from excel

Hi Mura - When you say 'send stationery mail' do you mean - Just a normal e-mail with no attachment???

If so then look at the new code posted on this site - I changed the code simply to allow the user to send an e-mail with or without the attachment. I can't post the example as the attachment system is still down

However I can e-mail it direct if you want. - The example still uses a Userform - but again this is not necessery as it could be driven by typing data directly into cell's or inputboxes - or from a range if multiple people require the e-mail.

The code was never written by me - just put together to get something that worked so I can't really take any credit, it's easier to play with something that works than it is to actually design a macro like this from scratch.

Phil

Hi Phil,

Thank you very much for your respose. Stationery mail in Lotus notes is a mail template. We create mail templates, which are saved in stationery folder in lotus notes. I dont know whether such feature is there in Outlook.

hi Mura - OK this is where the fun begins............

Basicly I'm not sure how the template system works within Lotus Notes - or how the call routine to allow you to change the templates.:(

However I suspect the following code within the current system selects the type of e-mail form to use:

Set MailDoc = Maildb.CreateDocument
MailDoc.Form = "Memo"

Here we are setting up the object type and defining the type of object form. I think you will find that your templates will have different names for each type of form. Again - it's a bit like the blind leading the blind!!!!!!

But that would be where I would start. Sorry I can't be of more help - as I don't have any templates within my Lotus Notes - and as it's on our network at work I can't play with it!!!!

Good luck in your quest - The only other suggestion I have is to contact:

Ivan Moana - He's a bit of a guru with this type of thing :pcangry:

Thanks Phil. Ivan, could you please help me in this.

Murali

Please Help me Ivan on this

Could you please help me in resolving this