Hi all,
Needed a vba for the following:
I have a database consists of order number, company name, and a group of email recipients on respective company.
In a form I've create a combo box, a text box and a send email button.
Combo box storing the order number and the text box will auto populate the company name based on the order number selected.
Each of the order will have a booking receipt in pdf format that stored on my pc in a fixed path and the file name is the order number. path = "C:\users\booking"
my requirement is:
1. user will select an order from the combo box and click the send email button
2. when the email button is click, perform the following:
a. go to outlook, create a new email
b. input email recipients based on the company
c. input email subject as "New Order xxx"
***where xxx = order number***
d. search and attached the booking receipt based on order number
e. input a standard message "xxx" in the email body text
Please let me know whether this can be achieved.
Needed a vba for the following:
I have a database consists of order number, company name, and a group of email recipients on respective company.
In a form I've create a combo box, a text box and a send email button.
Combo box storing the order number and the text box will auto populate the company name based on the order number selected.
Each of the order will have a booking receipt in pdf format that stored on my pc in a fixed path and the file name is the order number. path = "C:\users\booking"
my requirement is:
1. user will select an order from the combo box and click the send email button
2. when the email button is click, perform the following:
a. go to outlook, create a new email
b. input email recipients based on the company
c. input email subject as "New Order xxx"
***where xxx = order number***
d. search and attached the booking receipt based on order number
e. input a standard message "xxx" in the email body text
Please let me know whether this can be achieved.