D
danison
Hi
I have created a spreadsheet in Excel 2000 and want to set up a macro
on the file whereby I go file, send to, click 'To', insert the names of
the recipients from the address book, click Send.
When I do this using the Record Macro function it works the first time
as I am going through the motions of sending the file to people. After
that however the macro will not run.
I have tried using File Send To, as well as Send To (as attachment). Is
there some way I can arrange it so that the distribution list is set up
in Outlook 2000 and I can run a macro to send to this group everytime?
Thanks
Bill
I have created a spreadsheet in Excel 2000 and want to set up a macro
on the file whereby I go file, send to, click 'To', insert the names of
the recipients from the address book, click Send.
When I do this using the Record Macro function it works the first time
as I am going through the motions of sending the file to people. After
that however the macro will not run.
I have tried using File Send To, as well as Send To (as attachment). Is
there some way I can arrange it so that the distribution list is set up
in Outlook 2000 and I can run a macro to send to this group everytime?
Thanks
Bill