V
vic1
I have studied Ron de Bruin's pages (excellent) but, unless I have missed
something, I cannot find a solution to the following:
To conduct an audit of equipment existing on multiple sites, I need to
create a template for a 'blank' spreasheet which I wish to email to each
site, for them to fill in and return to me.
Ideally, I would like this template to be 'personalised' for each email
address so that the site reference and name is already completed (ie. so they
can't forget to fill it in themselves!).
I envisage that it should be possible to have one worksheet with the basic
template and a second worksheet listing all the recipients' email addresses,
together with their site names and reference numbers and then create a macro
which completes the individual site name and reference number on the template
at the same time as sending the email.
Is there a way to do this?
Many thanks for your efforts, which I have been very grateful for in the past!
something, I cannot find a solution to the following:
To conduct an audit of equipment existing on multiple sites, I need to
create a template for a 'blank' spreasheet which I wish to email to each
site, for them to fill in and return to me.
Ideally, I would like this template to be 'personalised' for each email
address so that the site reference and name is already completed (ie. so they
can't forget to fill it in themselves!).
I envisage that it should be possible to have one worksheet with the basic
template and a second worksheet listing all the recipients' email addresses,
together with their site names and reference numbers and then create a macro
which completes the individual site name and reference number on the template
at the same time as sending the email.
Is there a way to do this?
Many thanks for your efforts, which I have been very grateful for in the past!