Access to Lotus Notes

[spinkung]

Hi all,

I have a list box which has several columns. What i'm trying to do is have a button that when clicked takes the values of the selected list box item and put them into a new lotus notes email. It doesn't need the address or any other detail, just the info into a new mail. I have seen some post's here but not sure i understand them (bit of a noob to access/vba).

Is this possible to do and can someone please point me in the right direction?


Thanks,
Spinkung.

 

[Bogzla]

I found this page really useful:

http://www.bygsoftware.com/Excel/VBA/email_from_lotus_notes.htm

I have used the code and got it working perfectly from excel... I have to admit I've not used it with access but I guess it should work

hth
Bogzla

 

[Bogzla]

just wanted to add - i think it's the

With objNotesField
    .APPENDTEXT "This e-mail is generated by an automated process."
    .ADDNEWLINE 1
    .APPENDTEXT "Please follow established contact procedures should you
have any questions."
    .ADDNEWLINE 2
End With

bit you'd need to use, if you get the info from the listbox into a variable, something like:

YourVariableName = [Forms]![YourFormName]![ListBoxName]

then use

APPENDTEXT YourVariableName

 

[spinkung]

thanks for your help,

just tweaking the excel version you sent. hopefully that'll do the trick.



spinkung.