B
Bryan
Hi all. I have a question for ya.
I have several companies that I need to send a form via emal through excel.
This form is the same for all of the companies but has their name on the form.
I would like to have a master worksheet with the names of each company on it.
When I add a new company to the master worksheet I would like excel to
automatically create a new worksheet with the form on it so that I can simply
go to that worksheet and hit send sheet and it will email to the customer.
Does excel have an easy way of doing this? Do I have to write my own macro?
thanks
I have several companies that I need to send a form via emal through excel.
This form is the same for all of the companies but has their name on the form.
I would like to have a master worksheet with the names of each company on it.
When I add a new company to the master worksheet I would like excel to
automatically create a new worksheet with the form on it so that I can simply
go to that worksheet and hit send sheet and it will email to the customer.
Does excel have an easy way of doing this? Do I have to write my own macro?
thanks