LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Emailing with Lotus Notes to multiple, user entered, recipients

I've a workbook that needs to email the active sheet to multiple, user
entered, recipients using Lotus Notes. Thanks to lots of "borrowed" code
from here and other sites, I have the majority of the code done.

The bit I'm stuck on is how to collect the email address(es) from the user.
I've tried using an inputbox (which works if I only enter one address) and
I've tried hard coding the addresses using an array (which, although this
works, isn't the answer as the recipients will change from day to day).

What I think I need to do is combine the two.... but I have no idea how!

Please help

Jude
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with checkbox to select recipients of an E Maiil via Lotus Notes Francois via OfficeKB.com Excel Programming 3 April 20th 07 11:05 AM
Mail über Lotus Notes aus Excel heraus/ Sending Mail with Excel through Lotus Notes [email protected] Excel Programming 0 February 19th 07 12:11 PM
how to determine if user has Outlook or Lotus Notes jseven Excel Programming 1 July 1st 06 01:23 AM
emailing in Lotus Notes owl527[_2_] Excel Programming 1 October 13th 05 03:13 PM
Emailing Lotus Notes From Excel Charles Excel Programming 0 February 12th 04 03:24 PM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"