RE: Send Multiple Attachments from Outlook

Currently, when your users send out the emails, are they manually selecting
the files to attach? Are the files preexisting files or do are they created
shortly before the email is sent out?

"lgray" wrote:

I've seen solutions in the Developer threads that address the issue of
attaching multiple attachments to Outlook, but the names of the files stay
the same, (i.e. "Financial Results.xls", "Monthly Budget.doc") within the
Code.

In my case, the file names can vary, depending on the Customer file they are
working on. The names of the files that have been created are usually
prefixed with a Customer ID, then the category of file (ie Legal
contracts,".doc", Service applications,".xls", scanned pdfs). Depending on
the details of the employees task in reviewing the customer information, it
could be any number of files with any naming convention. Basicly they've
requested me to package the documents and send as an email.

I hope this helps clarify
--
Linda


"dch3" wrote:

I'm not following what you mean by the last statement "but is there a way to
attach these files with variable names?". Do mean using a variable in code
that is set to the file's name?

At any rate, when your working with the MailItem object, VBA doesn't care
where the name comes from - a table lookup, looping through a recordset,
using the common dialog, or even if its hard coded.

"lgray" wrote:

I've created a table that includes hyperlinks, file names and directory Path
to a group of documents that need to be attached and sent in one email. The
files that need to be attached are variable in both name as well as how many
files are to be attached. The files to be sent will be selected via a
"Yes/No, Checkmark" field type in a form. I know how to create a separate
table to include just the selected records to be sent, but is there a way to
attach these files with variable names?

--
Thanks
Linda
.

Relevant Pages

  • Re: Word-2003 - Track Changes
    ... Until Word 2000, if you clicked without selecting any text, and chose to ... If you select some text, even just one letter or a space, Word will attach ... Every time I and using track changes and want to enter a ...
    (microsoft.public.word.docmanagement)
  • Re: Word-2003 - Track Changes
    ... > Until Word 2000, if you clicked without selecting any text, and chose to ... > you, or Word, selecting any text. ... > If you select some text, even just one letter or a space, Word will attach ... > Track Changes. ...
    (microsoft.public.word.docmanagement)
  • Re: Mail Merge Source
    ... try unchecking it and then try and attach the data source and see ... I've never seen this box before and I tried selecting the ...
    (microsoft.public.word.mailmerge.fields)
  • Re: [opensuse] Email signature command execution help
    ... Settings you have the item Attach this Signature where you can specify ... the file to attach as the sig. ... Wouldn't selecting the file containing ...
    (SuSE)
  • Re: Double Click a List Item to Open an Associated File
    ... It contains an API that presents the Common File Open Dialog. ... this to allow the user to navigate to the file. ... List of Documents Received from a Customer ... I want them to have to option to "attach" a file to that list entry as it ...
    (microsoft.public.access.formscoding)