Send Macros with an Excek attachment using Outlook 2003

D

Dannyboy1001

I have a worksheet that has two buttons. The first button is used by a user
to submit (sent using the sendmail VB command) a request for approval. The
first button works fine. The document is attached to an Outlook message and
the message is forwarded to the "approver" for review.

The second button also has a VB send script that is used to send the
document for processing once it has been review and approved.

My issue is once the document is sent for approval it loses it's macros.
The second button no longer contains the VB macro. Is there a way to send an
EXCEL document via the sendmail command that ensures all macros are sent as
well?

Thanks in advance for you help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button - Send and Save 2
Building Blocks and Macros 5
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Mac Office 2011 Outlook email accounts behaving funny 0
Multiple Command Buttons 0
AUTOMATICALLY SENDING EMAIL VIA A MACRO 1

Top