Hi,
If you figured out how to do this, would you be willing to share?
--
diane


"Michael" wrote:

Michael,

Thanks for your response. Sometimes I don't do such a great job at
communicating ideas that I don't fully understand.

The list I was refering to was the distribution list.

This is what I had in mind:

creat an array of values for my D/L

(xyz, abc, 123) etc.

start a loop

if finished with array
end
else
open new message
sendto: (next array value)
enter subject text : "monthly report"
add attachment (file location based on array value) file based on most recent
send
loop

I mainly stuck on the choosing the file and I am thinking your suggestion
of scripting runtime would go in the middle of the loop where I am trying to
select the file.

As far as my mentioning prompting I was thinking about for only file
selction that it would just prompt me for a file and once I selected the file
the code would continue to the next value in the array.

I may be way off in my design.


"Michael Bauer" wrote:

Hi Michael,

sorry, but I don´t understand you.

What kind of list do you mean? And when do you want to be prompted?

Did you take a look at the Scripting Runtime, as I suggested?

--
Viele Grüße
Michael Bauer


"Michael" wrote in message
...
Thanks for your answer Michael, I am trying out somethings based on
your
response.

How would I macro it to just populate a new mail with the list and
then
prompt me for a file to attach. That would be quicker that what I do
now.

I was thinking that since my directory is the same name as my
distribution
list I could some how piece together a way to choose the file from
that?

Eventhoug I am learning some basics I am still a total novice when it
comes
to writing these pieces.

Thanks

Michael

"Michael Bauer" wrote:

Hi Michael,

the easiest way for getting the file informations would be the using
of
the FileSystemObject (Microsoft Scripting Runtime, scrrun.dll).

Once, you have the newest file, you can call CreateItem for a new
MailItem, and it´s Attachments.Add for adding the file.

--
Viele Grüße
Michael Bauer


"Michael" wrote in message
...
Is there a way to macro sending attachments to multiple
recipients. I
have
14 reports that go to 14 distribution lists. Each report going to
its
own
distribuing list. I do this once permonth and the distribution
list
is the
same but the report names are different. Example

xyz distribution list gets "c:\report\xyz\xyz report jan.xls"
abc distribuion list gets "c:\report\abc\abc report jan.xls"

etc.

The report being sent is always the most recent in the respective
directory.

Any suggestions are greatly appreciated

Hello Diane:

Did you get help and if so would you be willing to share???

Thanks,

Joel

" wrote:

Hi,
If you figured out how to do this, would you be willing to share?
--
diane


"Michael" wrote:

Michael,

Thanks for your response. Sometimes I don't do such a great job at
communicating ideas that I don't fully understand.

The list I was refering to was the distribution list.

This is what I had in mind:

creat an array of values for my D/L

(xyz, abc, 123) etc.

start a loop

if finished with array
end
else
open new message
sendto: (next array value)
enter subject text : "monthly report"
add attachment (file location based on array value) file based on most recent
send
loop

I mainly stuck on the choosing the file and I am thinking your suggestion
of scripting runtime would go in the middle of the loop where I am trying to
select the file.

As far as my mentioning prompting I was thinking about for only file
selction that it would just prompt me for a file and once I selected the file
the code would continue to the next value in the array.

I may be way off in my design.


"Michael Bauer" wrote:

Hi Michael,

sorry, but I don´t understand you.

What kind of list do you mean? And when do you want to be prompted?

Did you take a look at the Scripting Runtime, as I suggested?

--
Viele Grüße
Michael Bauer


"Michael" wrote in message
...
Thanks for your answer Michael, I am trying out somethings based on
your
response.

How would I macro it to just populate a new mail with the list and
then
prompt me for a file to attach. That would be quicker that what I do
now.

I was thinking that since my directory is the same name as my
distribution
list I could some how piece together a way to choose the file from
that?

Eventhoug I am learning some basics I am still a total novice when it
comes
to writing these pieces.

Thanks

Michael

"Michael Bauer" wrote:

Hi Michael,

the easiest way for getting the file informations would be the using
of
the FileSystemObject (Microsoft Scripting Runtime, scrrun.dll).

Once, you have the newest file, you can call CreateItem for a new
MailItem, and it´s Attachments.Add for adding the file.

--
Viele Grüße
Michael Bauer


"Michael" wrote in message
...
Is there a way to macro sending attachments to multiple
recipients. I
have
14 reports that go to 14 distribution lists. Each report going to
its
own
distribuing list. I do this once permonth and the distribution
list
is the
same but the report names are different. Example

xyz distribution list gets "c:\report\xyz\xyz report jan.xls"
abc distribuion list gets "c:\report\abc\abc report jan.xls"

etc.

The report being sent is always the most recent in the respective
directory.

Any suggestions are greatly appreciated

I have an Excel spreadsheet with some vba code to do this. It worked until
our IT dept "upgraded" to a new version of Outlook. If someone can help me
debug, I'll gladly share it.

"Joel" wrote:

Hello Diane:

Did you get help and if so would you be willing to share???

Thanks,

Joel

" wrote:

Hi,
If you figured out how to do this, would you be willing to share?
--
diane


"Michael" wrote:

Michael,

Thanks for your response. Sometimes I don't do such a great job at
communicating ideas that I don't fully understand.

The list I was refering to was the distribution list.

This is what I had in mind:

creat an array of values for my D/L

(xyz, abc, 123) etc.

start a loop

if finished with array
end
else
open new message
sendto: (next array value)
enter subject text : "monthly report"
add attachment (file location based on array value) file based on most recent
send
loop

I mainly stuck on the choosing the file and I am thinking your suggestion
of scripting runtime would go in the middle of the loop where I am trying to
select the file.

As far as my mentioning prompting I was thinking about for only file
selction that it would just prompt me for a file and once I selected the file
the code would continue to the next value in the array.

I may be way off in my design.


"Michael Bauer" wrote:

Hi Michael,

sorry, but I don´t understand you.

What kind of list do you mean? And when do you want to be prompted?

Did you take a look at the Scripting Runtime, as I suggested?

--
Viele Grüße
Michael Bauer


"Michael" wrote in message
...
Thanks for your answer Michael, I am trying out somethings based on
your
response.

How would I macro it to just populate a new mail with the list and
then
prompt me for a file to attach. That would be quicker that what I do
now.

I was thinking that since my directory is the same name as my
distribution
list I could some how piece together a way to choose the file from
that?

Eventhoug I am learning some basics I am still a total novice when it
comes
to writing these pieces.

Thanks

Michael

"Michael Bauer" wrote:

Hi Michael,

the easiest way for getting the file informations would be the using
of
the FileSystemObject (Microsoft Scripting Runtime, scrrun.dll).

Once, you have the newest file, you can call CreateItem for a new
MailItem, and it´s Attachments.Add for adding the file.

--
Viele Grüße
Michael Bauer


"Michael" wrote in message
...
Is there a way to macro sending attachments to multiple
recipients. I
have
14 reports that go to 14 distribution lists. Each report going to
its
own
distribuing list. I do this once permonth and the distribution
list
is the
same but the report names are different. Example

xyz distribution list gets "c:\report\xyz\xyz report jan.xls"
abc distribuion list gets "c:\report\abc\abc report jan.xls"

etc.

The report being sent is always the most recent in the respective
directory.

Any suggestions are greatly appreciated