LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 284
Default open outlook and add email address

You're welcome.

You can also have additional arguments using the same format but each
argument separated by a comma. arg2 would be used if you want to pre-set
the 'Subject' line and arg3 could be set to true or false to indicate you
wanted a return receipt.

Steve



"Debbie Horner" wrote in message
...
Nevermind...
When I first saw it...it displayed as two different lines...when I got a
bigger screen and saw that you had it on the same line...I moved it and it
works like a charm!!!

Thanks a million!

"Steve Yandl" wrote:

Debbie,

Try
Application.Dialogs(xlDialogSendMail).Show "

If you want more than one address, just separate addresses in the list
with
semicolons and enclose the entire string in double quotes.


Steve Yandl




"Debbie Horner" wrote in message
...
I want to open the Outlook dialog box and populate the "to address" with
an
email address - I do not want the email to automatically send. I
currently
have code which opens up the dialog box fine..just need to add email
address
to it..

code is currently
Application.Dialogs(xlDialogSendMail).Show

Thank you






 
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
How do I link an email address in a cell to a MS Outlook template Jim Stevenson Excel Discussion (Misc queries) 1 February 24th 10 03:54 AM
How would you access an email address in Outlook from excel? sungen99[_93_] Excel Programming 0 May 8th 06 08:05 PM
extracting email address from Outlook Daminc[_37_] Excel Programming 1 January 26th 06 03:14 PM
transfer email address cells from excel to outlook paul2006 Excel Discussion (Misc queries) 1 January 23rd 06 04:12 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 02:26 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"