Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2021, 01:15 AM
JacquesW JacquesW is offline How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Windows 10 How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Office 2013
Novice
How to generate a Lotus Notes email with VBA code and thereafter open de LN client?
 
Join Date: Jan 2012
Posts: 21
JacquesW is on a distinguished road
Smile How to generate a Lotus Notes email with VBA code and thereafter open de LN client?

How to generate a Lotus Notes email with VBA code and thereafter open de LN client?


I have searched on the net to find VBA code to generate an email in Lotus Notes.

I only found code that generates mail attaches the current sheet or workbook and sends the mail.

The problem is that all these codes end with "Call Maildoc.send(False)".
And that immediately sends the message.

What I want th code to do is:
Attach the code to a button within an excel workbook/-sheet.
When the user klicks on it the mail wil be generated.
Instead of directly sending the mail I want it to open in Lotus Notes.
Purpose is that the sender can change the body and can add an attachment if necessary.

I hope somebody can help me with this.

Thanks in advance.
Reply With Quote
  #2  
Old 03-12-2021, 12:00 AM
gibra's Avatar
gibra gibra is offline How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Windows 10 How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Office 2019
Novice
 
Join Date: Mar 2021
Posts: 8
gibra is on a distinguished road
Default

If Lotus Notes is the default mailer you can use MAILTO protocol (with no attachments)

or see :

Lotus Notes Mail code examples from Dennis Wallentin
Reply With Quote
  #3  
Old 03-29-2021, 07:25 AM
JacquesW JacquesW is offline How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Windows 10 How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Office 2013
Novice
How to generate a Lotus Notes email with VBA code and thereafter open de LN client?
 
Join Date: Jan 2012
Posts: 21
JacquesW is on a distinguished road
Post Not. What I am looping for

Imknow the mailto command.
But that is not what I am looping for.
And the page you suggesties I already scanned for an answer.
All code sends the mail directly.
I want it to generate the message body tekst included and then open the LN client.
Then the sender can fill in the desired adressen and of nessessary add an other attachment and then zend the mail.

That is not included in one of the codes.
Reply With Quote
Reply

Tags
generate mail, lotus notes

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generate QR Code in Word 2010 pacojones Word 4 11-03-2020 12:28 PM
Question on Stationary coming from Lotus Notes to Outlook 2013 AdvOfJet Outlook 0 10-03-2016 08:13 AM
Pie chart donut changes when emailed with Lotus Notes cao428 PowerPoint 0 07-17-2015 06:23 AM
How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Generate sequential code tags ssarank Word VBA 3 12-25-2013 02:44 AM
How to generate a Lotus Notes email with VBA code and thereafter open de LN client? Word attachment with Lotus Notes MRomanow Word 1 08-20-2009 02:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft