Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default E-mail date from a sheet TEXT only

I would like to have a CMB BTN that would send that data on a sheet to E-mail
text only. I know how to do this is access with a CMD BNT with the
DoCmd.SendObject. I would like to do the same in excel so the user can just
hit the CMD BNT and it would send the E-mail. Can I do this?

Keith
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default E-mail date from a sheet TEXT only

Hi KAnoe

See my site for example code
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"KAnoe" wrote in message ...
I would like to have a CMB BTN that would send that data on a sheet to E-mail
text only. I know how to do this is access with a CMD BNT with the
DoCmd.SendObject. I would like to do the same in excel so the user can just
hit the CMD BNT and it would send the E-mail. Can I do this?

Keith



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default E-mail date from a sheet TEXT only

I do not see how to do it as text only. I can't use/send a sheet. I would
like it to put the data into the text of the E-mail.

Did I miss it on the site?

Keith

"Ron de Bruin" wrote:

Hi KAnoe

See my site for example code
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"KAnoe" wrote in message ...
I would like to have a CMB BTN that would send that data on a sheet to E-mail
text only. I know how to do this is access with a CMD BNT with the
DoCmd.SendObject. I would like to do the same in excel so the user can just
hit the CMD BNT and it would send the E-mail. Can I do this?

Keith




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default E-mail date from a sheet TEXT only

I found it THNAKS!!!!

"Ron de Bruin" wrote:

Hi KAnoe

See my site for example code
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"KAnoe" wrote in message ...
I would like to have a CMB BTN that would send that data on a sheet to E-mail
text only. I know how to do this is access with a CMD BNT with the
DoCmd.SendObject. I would like to do the same in excel so the user can just
hit the CMD BNT and it would send the E-mail. Can I do this?

Keith




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
Date format to Text Date for use in Mail Merge Erinayn Excel Discussion (Misc queries) 3 April 22nd 10 06:04 AM
E-mail one sheet Lella New Users to Excel 1 October 12th 07 08:30 PM
How do I mail merge 2nd sheet of an excel sheet? Deh_Dot Excel Discussion (Misc queries) 2 August 17th 07 01:51 AM
Add date or text to sheet name formula laralea Excel Worksheet Functions 1 September 11th 06 05:38 AM
One sheet e-mail Attlee vba Excel Programming 1 October 16th 05 11:40 AM


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