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: 4
Default setting address in "mail as attachment" macro

P.S. I did just check out the recent thread with the macro suggestion by
Ron de Bruin, which is pretty close to what I'm going for, except that I
would like to have the email window remain open (so that the subject field
can be modified) instead of having it shot out directly.

------
"Alan D." wrote in message
...
I'm afraid I'm not clear on these instructions. I don't find a
"Tools=References" path in either Excel (2000) or Outlook. Also, as my
intention is to also allow access to this form over the internet, I'm
wondering if defining the mail client application as Outlook might be a
litttle restrictive. Is there any other way to generate a more generic
email, like with a mailto hyperlink, with the Excel form - in whatever

it's
current state of completion - attached? Thanks.

Alan D.

------
"kedarkulkarni " wrote in
message ...
hi
set a reference to
Microsoft Outlook Library XX
by tools - references..
should work fine,


---
Message posted from http://www.ExcelForum.com/





 
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
Excel hangs after using "Send to mail recipient (as attachment) " Rob Excel Discussion (Misc queries) 1 November 11th 09 10:16 PM
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, sarah Excel Worksheet Functions 2 February 17th 09 02:59 PM
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? sarah Excel Worksheet Functions 0 February 17th 09 02:06 PM
Default format for "mail recipient as attachment" emails Pete at Sappi Fine Paper Excel Discussion (Misc queries) 0 July 25th 07 03:58 PM
Excel: "De-activating" an e-mail address cell? HowdyPete Excel Discussion (Misc queries) 2 August 17th 06 04:18 PM


All times are GMT +1. The time now is 05:30 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"