Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default How can I make a custom button in one Excel form to e-mail easily.

I have many computer users in my company that are not computer literate in
day to day activities. I need to get more of them to send documents to
individual people within the organizatin without constantly training them how
to e-mail a document. I want to have a button inside of an Excel form that
is tied to a macro or something that will direct the form to the correct
person. I have Visual Basic, but no clue how to use it. I tried to write a
macro to handle it, but it seems that the e-mail is outside of excel because
the macro did not record the send to mail recipient activities. Any
suggestions?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default How can I make a custom button in one Excel form to e-mail easily.

Katy,

Ron has tons of help on his site at www.rondebruin.nl/sendmail.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Katydid" wrote in message
...
I have many computer users in my company that are not computer literate in
day to day activities. I need to get more of them to send documents to
individual people within the organizatin without constantly training them

how
to e-mail a document. I want to have a button inside of an Excel form

that
is tied to a macro or something that will direct the form to the correct
person. I have Visual Basic, but no clue how to use it. I tried to write

a
macro to handle it, but it seems that the e-mail is outside of excel

because
the macro did not record the send to mail recipient activities. Any
suggestions?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 983
Default How can I make a custom button in one Excel form to e-mail easily.

Ron has a great site for this...

http://www.rondebruin.nl/

HTH

"Katydid" wrote:

I have many computer users in my company that are not computer literate in
day to day activities. I need to get more of them to send documents to
individual people within the organizatin without constantly training them how
to e-mail a document. I want to have a button inside of an Excel form that
is tied to a macro or something that will direct the form to the correct
person. I have Visual Basic, but no clue how to use it. I tried to write a
macro to handle it, but it seems that the e-mail is outside of excel because
the macro did not record the send to mail recipient activities. Any
suggestions?

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
How can I easily make cells in Excel that are square? Todd Excel Discussion (Misc queries) 8 February 4th 09 07:39 PM
Creating a form on a worksheet - Can I make a button for "notes" [email protected] Excel Worksheet Functions 3 October 6th 05 04:50 PM
Excel should allow you to change custom colours more easily Gee Excel Discussion (Misc queries) 0 July 7th 05 12:10 AM
Can I make a custom button in Excel for the Group feature? Lisa Excel Worksheet Functions 1 December 20th 04 09:34 PM
how to make a multipage with many pages all of which can be seen easily. youngman Excel Programming 3 October 8th 03 01:53 AM


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