Sending Attachments to recipients
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
|