Attachment issues...

[prt75 via OfficeKB.com]

Does anyone out there know a good VBA reference for automatically adding
attachments to custom forms? All I want to do is write a script that will
grab a file (whose name constantly changes with the date) from a folder
(whose name also changes with the date) - so that a user can just open the
form, see that the correct attachments are there, and click "send".

I have to send these attachments daily and its a real pain. All I know is
that I need a message field for the code to work. Anybody?

 

[Hollis Paul]

I have to send these attachments daily and its a real pain. All I know is
that I need a message field for the code to work. Anybody?

Actually, you are really wanting to use something called an Action Item.
This is data item that sits in one of your folders, you open it, it runs
the code behind the form to do the function you want, and then you close it
when you are done. I prefer to use a Contact item, and yes, it does have a
Notes field, so it can run code. For an example of one such action item,
you can see the following example posted on my blog:

Automating Tip Capture with Office Systems 2003 – Part 1
http://msmvps.com/blogs/obts/archive/2005/10/19/71691.aspx - 78 KB

Automating Tip Capture with Office Systems 2003 - Part 2
All you ever wanted to know about the code. The first section in the code
gives credit where credit is due. The SharePoin...
http://msmvps.com/blogs/obts/archive/2005/10/19/71693.aspx - 139 KB

Part 1 discusses what I am trying to do - which includes creating a new
message and attaching a file to it and then sending it. Part 2 gives you
all the code I use and describes, in detail, what the code does.

 

[Sue Mosher [MVP-Outlook]]

I'm confused: You asked about a VBA *and* custom forms. The code behind a custom form is VBScript, not VBA.

But more important is -- to whom are you sending these messages that you create from a custom form? Is it only to people inside your organization? If not, then you may need to rethink this scenario.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers