Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default VBA code or macro to auto e-mail spreadsheet

I need some sort of "button" or "icon" to automatically attach a workbook to
an e-mail to be sent to a designated e-mail address.

I'm working in Office Standard 2007, however the majority of my co-workers
have Office Standard 2003.

I've only ever been able to get a macro or code to work when somebody off
this discussion group gave me all the steps from where to put the code, etc.
to get this done, so if anybody could help me to that extent I would greatly
appreciate it.

Please let me know what other questions you have.

Thanks,

Nancy
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 709
Default VBA code or macro to auto e-mail spreadsheet

Nancy, have a look at Ron's page here,
http://www.rondebruin.nl/sendmail.htm#Tips
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"NANGO" wrote in message
...
I need some sort of "button" or "icon" to automatically attach a workbook
to
an e-mail to be sent to a designated e-mail address.

I'm working in Office Standard 2007, however the majority of my co-workers
have Office Standard 2003.

I've only ever been able to get a macro or code to work when somebody off
this discussion group gave me all the steps from where to put the code,
etc.
to get this done, so if anybody could help me to that extent I would
greatly
appreciate it.

Please let me know what other questions you have.

Thanks,

Nancy



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default VBA code or macro to auto e-mail spreadsheet

Just last night I used some code from Ron's site to automate several emails.

Worked Great!

Paul B wrote:
Nancy, have a look at Ron's page here,
http://www.rondebruin.nl/sendmail.htm#Tips
I need some sort of "button" or "icon" to automatically attach a workbook
to

[quoted text clipped - 15 lines]

Nancy


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

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 do I do an e-mail mail merge using an Excel spreadsheet? Gretchen Excel Worksheet Functions 0 July 19th 09 05:18 PM
How to code VBA: Auto open workbook and run macro March Excel Discussion (Misc queries) 4 November 8th 07 08:25 PM
Auto Open file to run Mail macro nospaminlich Excel Programming 1 October 23rd 06 08:20 PM
Creating TWO-WAY E-Mail Attachments with 'BeforeSave Events' in Code for 2nd E-Mail Chuckles123[_112_] Excel Programming 0 September 8th 05 05:56 PM
How: open a workbook with auto macro disabled using code? mike_cutting-edge Excel Programming 1 February 13th 05 06:29 PM


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