Create macro program to automatically email outlook with a visible cell range

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Create macro program to automatically email outlook with a visible cell range

#15

03-05-2015, 05:49 PM

charlesdh

Windows 7 32bit Create macro program to automatically email outlook with a visible cell range

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

Hi,

You can have a macro run when you use a workbook open event.
As for books look on amazon. They have a great selection of books.

Code:

Private Sub Workbook_Open()
''' This code needs to be in the "Thisworkbook module

Run "MyMacro"''' this will call the code you want to run

End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically add firm name to visible contactname	spqr²	Outlook	0	12-29-2014 03:24 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Email macro to read range for .To field	MattMurdock	Excel Programming	2	08-07-2012 06:46 AM
Can't create new email or access email acounts Outlook 2003	onthebeaches	Outlook	1	02-20-2012 10:21 PM
Outlook Not Sending Automated Email Unless Visible	RMittelman	Outlook	0	12-10-2010 11:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:03 AM.