Direct email using macro

J

jamshoot

Board Regular
Joined
Oct 15, 2009
Messages
199
Hi there

Right now, I am using the below Work Order Form for staff who require work repair in their Office. After filling the form, they will drop into my Office tray. I will then acknowledge & proceed with the repair job. After completion, I have to fill up the below section & return to the requestor to inform job is done.
I am looking for help whether is this possible to use macro to have the requestor to send the form by email to me. (SEND button)
After I have done the job, I can have another macro to return the completed form to requestor (SEND button)
I hope it doesn't sound too complicated ... hoping someone can me with a macro solution.

Cheers


<table border="1" cellpadding="0" cellspacing="0"><tbody><tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">WORK ORDER FORM</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Requestor :_________________________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Time : _______________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Date Reported :____________________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Level : _______________</td> <td>
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Location : _________________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td>
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Room No. : _____________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; TEXT-DECORATION: underline">Description of problem :</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</td> <td style="FONT-STYLE: italic; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">*** Click SEND button after completion</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold">
</td> <td>
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99cc00; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold">SEND BUTTON</td> <td style="TEXT-ALIGN: left; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Click & email to Operation at xyz@yahoo.com</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 24px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 24px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">OPERATIONS</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Job Completion Date : _______________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Time : _______________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Contractor : ___________________________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Checked By : _________________________</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Description of Repair / Replacement :</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99cc00; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold">SEND BUTTON</td> <td style="TEXT-ALIGN: left; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">Click & email back to requestor abc@yahoo.com</td> <td>
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td></tr></tbody></table>
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
619
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
574
mumps
mumps
E
  • Question Question
Adding a custom message.
Replies
1
Views
660
Micron
M
D
  • Question Question
VBA to Create Outlook Email Not Working for All Users
Replies
9
Views
356
Logit
Logit
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G

Forum statistics

Threads
1,224,552
Messages
6,179,487
Members
452,917
Latest member
MrsMSalt

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top