aloy78
12-18-2016, 08:03 PM
Hi Guys/Gals,
I would like to be able to generate an email based on clicking on a cell (e.g. L3) in a certain column (L). The macro will retrieve cell values from the row (3) and put them in the email and also attach files found in the folder file path in that same row. So if I click cell (L4), it will retrieve cell values from row (4) and so forth. Any help is very much appreciated.
A
B
C
D
E
F
G
H
I
J
K
L
1
2
Order date
Status
Email Subject
Email Body
Invoice#
No. of Pkg
Kg
Shipped Date
Client email Address
Folder File Path
Click to sent email
3
1/12
Order complete
REF: Your Order 2016-REF 01
Dear Sir/Mdm,
Your order has been process. Please take note of:
2016-REF 01
1
14
1/12
abby@test.com; david@test.com
C:\Order\2016\2016-REF 01
email
4
1/12
sending
REF: Your Order 2016-REF 02
Dear Sir,
Your order has been process. Please take note of:
2016-REF 02
1
14
3/12
danny@test.com
C:\Order\2016\2016-REF 02
email
Email sample generate will look something like this:
To: abby@test.com; david@test.com
Cc:
Subject: REF: Your Order 2016-REF 01
Attachment: Your invoice 2016-REF 01.doc, (files from the folder C:\Order\2016\2016-REF 01)
Operating Manual.pdf, (files from the folder C:\Order\2016\2016-REF 01)
Receipt of acknowledgement.doc (files from the folder C:\Order\2016\2016-REF 01)
Dear Mdm,
Your order has been process. Please take note of:17860
Invoice #: 2016-REF 01
No. of Pkgs: 1
Weight Kg: 14
Date Shipped Out: 01/12/2016
Thank You.
I would like to be able to generate an email based on clicking on a cell (e.g. L3) in a certain column (L). The macro will retrieve cell values from the row (3) and put them in the email and also attach files found in the folder file path in that same row. So if I click cell (L4), it will retrieve cell values from row (4) and so forth. Any help is very much appreciated.
A
B
C
D
E
F
G
H
I
J
K
L
1
2
Order date
Status
Email Subject
Email Body
Invoice#
No. of Pkg
Kg
Shipped Date
Client email Address
Folder File Path
Click to sent email
3
1/12
Order complete
REF: Your Order 2016-REF 01
Dear Sir/Mdm,
Your order has been process. Please take note of:
2016-REF 01
1
14
1/12
abby@test.com; david@test.com
C:\Order\2016\2016-REF 01
4
1/12
sending
REF: Your Order 2016-REF 02
Dear Sir,
Your order has been process. Please take note of:
2016-REF 02
1
14
3/12
danny@test.com
C:\Order\2016\2016-REF 02
Email sample generate will look something like this:
To: abby@test.com; david@test.com
Cc:
Subject: REF: Your Order 2016-REF 01
Attachment: Your invoice 2016-REF 01.doc, (files from the folder C:\Order\2016\2016-REF 01)
Operating Manual.pdf, (files from the folder C:\Order\2016\2016-REF 01)
Receipt of acknowledgement.doc (files from the folder C:\Order\2016\2016-REF 01)
Dear Mdm,
Your order has been process. Please take note of:17860
Invoice #: 2016-REF 01
No. of Pkgs: 1
Weight Kg: 14
Date Shipped Out: 01/12/2016
Thank You.