VBA and Macros

The UK's most regular instructor-led training courses.
Training information: excel+training+london · Excel courses london · VBA training in London

Resolved · Low Priority · Version Standard

VBA and Macros

Stephenie has attended:
Excel Advanced course

by - delegate Stephenie [1 post] (2008 Feb 20 Wed, 16:43) Reply

Jusdt wondering if it is possible to write a sub routine in VBA or as a macro to post a notice to outlook users prior to sending a group email or sending to a distribution list

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: VBA and Macros

by - trainer Rich platinum contributer [654 posts] (2008 Apr 4 Fri, 11:39) Reply

Hi

What do you mean by 'notice'? Is that a feature of Outlook or VBA?

For sending an e-mail via VBA, check out these sites:

http://www.ozgrid.com/VBA/send-email.htm
http://bytes.com/forum/thread447877.html

See also:
http://www.febooti.com/products/command-line-email/online-help/send-vba-email-macro.html

Regards, Rich

· A Beginners Guide To Formulas In Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Tips to Facilitate Printing of Excel worksheets
· How to check for and reduce errors in Microsoft Excel
· Microsoft Office and the Small Business: Part 1 Excel

Please browse our web site to find out more about
excel+training+london and other Microsoft training courses.

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips