We want to generate a .pdf file for every gardens (containing their individual information) from the above chart(containing the information of all gardens) and send an email with these document to their corresponding email addresses, and also want to perform the total job by a single click on a button object.that means by clicking once a button we can send a number of emails to many gardens containing only their information not the whole information of the chart.please send the macro.
