Slamat Ale
New Member
* Need to Change "A1" Cell till last serial number in address sheet, & Selection of "B4: R19" send email via outlook as PDF format.
* I have approx 73 email address, I lookup all data from serial Number. When Serial Number change all data change.
* Need loop until Last serial number appear.
You can download this file from https://1drv.ms/x/s!AuzvYK0snzo7hzHw-JztJRpht3Xn
Please solve my prob.
Last edited: