Macro to e-mail spreadsheet

B

Bublin

Joined
Oct 23, 2009
Messages
1
Reaction score
0
Need help fast!!!! Macro to e-mail spreadsheet with specific info

I need to change the macro I currently use to email an excel spreadsheet so that it emails to a specific email address and enters data (from 2 cells in the spreadsheet) into the subject line. I am not real good with these things so if anyone can help - I would greatly appreciate it! Here is the macro I currently use:

ActiveWorkbook.UNPROTECT
Sheets("ACKNOWLEDGMENT").Select
ActiveSheet.UNPROTECT
Sheets("ACKNOWLEDGMENT").Select
Sheets("ACKNOWLEDGMENT").COPY
Sheets("ACKNOWLEDGMENT").Select
Sheets("ACKNOWLEDGMENT").Name = "COMPLETED ACKNOLEDGEMENT"
Range("G4:H4").Select
Application.Dialogs(xlDialogSendMail).Show
Windows("USTruckbuilder10.15.2009(version1)-1.xls").Activate
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Order Form").Select
ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub



Thanks!
Bublin
 
Last edited:

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

Assign a macro to the save button 4
Copy a sheet and all formats to a new sheet 3
Refreshing External Data 1
VBA to CC Email Address? 1
Automatic Unprotect / Protect 8
Unhide, Unprotect, Enter Password 2
macro to sort is missing top row out??? 4
Macro to add sheets works sporadically 2

Top