Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 897
Default Checking Outlook Email Address

Glad to hear it!

--JP

On Sep 18, 12:20*pm, Trefor wrote:
JP,

Many thanks for you help, your comments prompted to look in the Outlook
forum and I found a few hints and just tested by revised code (which is
essentially what you said below).

* * * * If EDisplayorSend = "Send" Then
* * * * * * If .Recipients.ResolveAll Then
* * * * * * * * .Send
* * * * * * Else
* * * * * * * * .Display
* * * * * * End If
* * * * Else
* * * * * * .Display
* * * * End If

--
Trefor


Reply
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
Insert email address from Outlook into ActiveCell LuisE Excel Programming 0 December 17th 07 10:00 PM
Insert email address from Outlook into ActiveCell LuisE Excel Programming 0 December 17th 07 10:00 PM
open outlook and add email address Debbie Horner Excel Programming 5 November 8th 07 12:12 AM
extracting email address from Outlook Daminc[_37_] Excel Programming 1 January 26th 06 03:14 PM
Put Email Address from Excel to Outlook Terry Excel Programming 1 January 29th 04 08:40 AM


All times are GMT +1. The time now is 07:50 AM.

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"