Re: Sending Attachments to recipients
From: Michael (Michael_at_discussions.microsoft.com)
Date: 02/04/05
- Next message: bxb7668: "Append Subject Line to File"
- Previous message: Michael: "Re: Sending Attachments to recipients"
- In reply to: Michael Bauer: "Re: Sending Attachments to recipients"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Feb 2005 08:05:07 -0800
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" <Michael@discussions.microsoft.com> wrote in message
> news:BA71EF47-CD17-4759-9F47-7A0FEF4C3EF6@microsoft.com...
> > 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" <Michael@discussions.microsoft.com> wrote in message
> > > news:1C5F6179-6232-4952-B1AE-244E62429E2D@microsoft.com...
> > > > 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
> > >
> > >
>
>
- Next message: bxb7668: "Append Subject Line to File"
- Previous message: Michael: "Re: Sending Attachments to recipients"
- In reply to: Michael Bauer: "Re: Sending Attachments to recipients"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
