Hi guys,
I'm still relatively new to VBA but I have been following a few threads on here and hope you may be able to help.
I'm currently working on new travel booking spreadsheet for my company and am looking for a macro that will do the following on a selected row.
1) Open a new email message in outlook
2) Fill the "To" field in outlook with the value of column A
3) Fill the body field as per the template below -
Hi [Provider]<o
></o
>
<o
></o
>
May you please make the following booking?<o
></o
>
<o
></o
>
Traveldate: (Column C) <o
></o
>
Name: (Column D) <o
></o
>
Reference number: (Column F) <o
></o
>
Contactnumber: (Column M) <o
></o
>
<o
></o
>
Collection Time: (Column G) <o
></o
>
Appointment Time: (Column H) <o
></o
>
Collection Address: (Column I) <o
></o
>
Destination Address: (Column K) <o
></o
>
Return Collection Time: (Column O)
Any help would be greatly appreciated!
Thanks!
I'm still relatively new to VBA but I have been following a few threads on here and hope you may be able to help.
I'm currently working on new travel booking spreadsheet for my company and am looking for a macro that will do the following on a selected row.
1) Open a new email message in outlook
2) Fill the "To" field in outlook with the value of column A
3) Fill the body field as per the template below -
Hi [Provider]<o


<o


May you please make the following booking?<o


<o


Traveldate: (Column C) <o


Name: (Column D) <o


Reference number: (Column F) <o


Contactnumber: (Column M) <o


<o


Collection Time: (Column G) <o


Appointment Time: (Column H) <o


Collection Address: (Column I) <o


Destination Address: (Column K) <o


Return Collection Time: (Column O)
Any help would be greatly appreciated!
Thanks!