L
Legacy 400604
Guest
Hi All,
Very new to VBA and learning on a daily basis albeit very slowly.
However, I have a project which needs to be completed urgently and hence reaching out for help.
Project Details: The business has set up a new warehouse facility. We have 100+ suppliers who currently deliver into 5 different warehouse facilities. Based on the specific suppliers who deliver to a specific warehouse, we need to send them a specific word document informing them of the new delivery point. Not all suppliers deliver to all warehouses and hence the word document needs to be specific to their criteria. This criteria will be determined by a specific cell value in Excel (lets say B1). Column A contacts a list of the Supplier Name(s).
Requirement: Need to create a macro which looks at the cell B1 and based on the value, refer to a separate worksheet which contains the Supplier Name, Supplier Contact, Supplier Email Address and then populate the email message (outlook 2010) with the relevant details along with the specific word document attached in the email.
Email to be sent as follows:
To: Supplier Email Address
Attachment: Specific Word document attachment based on cell value B1 in Excel workbook
Dear xxxx - Supplier Contact
Email body: We would like to inform you of our new warehouse..... (same static message to the supplier)
In a nutshell, seems a difficult project however I am sure with experts such as yourselves, there must be a way to do this using VBA. I have read some of Ron de Bruin's work and that gives me the confidence it is possible. Problem is just dont know how?
Thank you all, for any support and assistance you can provide.
Very new to VBA and learning on a daily basis albeit very slowly.
However, I have a project which needs to be completed urgently and hence reaching out for help.
Project Details: The business has set up a new warehouse facility. We have 100+ suppliers who currently deliver into 5 different warehouse facilities. Based on the specific suppliers who deliver to a specific warehouse, we need to send them a specific word document informing them of the new delivery point. Not all suppliers deliver to all warehouses and hence the word document needs to be specific to their criteria. This criteria will be determined by a specific cell value in Excel (lets say B1). Column A contacts a list of the Supplier Name(s).
Requirement: Need to create a macro which looks at the cell B1 and based on the value, refer to a separate worksheet which contains the Supplier Name, Supplier Contact, Supplier Email Address and then populate the email message (outlook 2010) with the relevant details along with the specific word document attached in the email.
Email to be sent as follows:
To: Supplier Email Address
Attachment: Specific Word document attachment based on cell value B1 in Excel workbook
Dear xxxx - Supplier Contact
Email body: We would like to inform you of our new warehouse..... (same static message to the supplier)
In a nutshell, seems a difficult project however I am sure with experts such as yourselves, there must be a way to do this using VBA. I have read some of Ron de Bruin's work and that gives me the confidence it is possible. Problem is just dont know how?
Thank you all, for any support and assistance you can provide.