How to send several documents (Office XP)

Topic

New Reply

Situation:
I have 3 documents open in Word
and I want to send them all with Outlook.

To send a document by e-mail I use File/Send to and Mail Recipient (as Attachment) when I have the document open in Word
How can I send all 3 documents the same way???

I have tried to open Windows Explorer, mark all 3 documents and then rightclick and select Send to (as attchment)
But only one document will be attached to the e-mail (it will be the document that I click on)

Having several documents to be dispatched it sound “stupid “to send several e-mails!!

Can anyone help?

Thanks in advance!!

regards
Bjorn

Reply | Quote

Replies

File/Send To is meant as a short method for sending the current document. I don’t think you can force it to handle multiple open documents. If you look at the Word object model in VBA, you’ll notice that SendMail is a method of the Document object, not of the Application object.

Of course, you can insert multiple (stored) documents in a single e-mail by selecting Insert/File… in an Outlook message, or by dragging and dropping from Windows Explorer into an Outlook message, or by selecting multiple documents in Windows Explorer, and selecting Send To/E-mail Recipient from the right-click menu.

Reply | Quote

Hi,

Thanks,

Attaching documents stored in SharePoint when a mail is started will not “open” the document and collect the version number that is to be inserted in the document. The version number can ONLY be collected when the document is opened from SharePoint. Inserting a document into the e-mail does not start the Document_Open macro which collects the version number.

When using the rightclick method in Widows Explorer the Document_Open macro runs and I get the correct version number placed/inserted on the document. That’s why I have to use this method when sending a document with an e-mail. As I have experienced only one document can be sent with this method, but I’m looking for an additional method with which I can send all documents marked.

As said above, using the insertion method (Attach file) in an e-mail does not give the same result.

Bjorn

Reply | Quote

If the three documents are already open, then do you have all the information you need?

If so, you could create a macro to automate Outlook and attach all of the open files (actually, the saved versions of those files, since you would give Outlook the paths of the files in the Documents collection). If you want the user to have a choice to send some-but-not-all of the files, more work is involved; some kind of listbox perhaps…

Reply | Quote

Thanks jscher2000

I must try that after easter.

Funny that Microsoft hasn’t provided several docs to be sent that way.
Funny is also the fact that either using File/Send to in Word or rightclick and send to in Windows Explorer enables the Document_Open macro to start while attaching the documents in a mail does not give the same effect.

Have a nice Easter and thanks for many good advices and communication.

Regards
Bjorn

Reply | Quote

Seems pretty easy if you do this from the Word Open dialog.
Even with the documents open, select the files, right-click | Send To | Mail Recip…..

Reply | Quote

Thanks Kevin,
Times goes when easter has come in between.

I tried this but I only got one document attached to the e-mail.

First try: start Word, click Open, select (mark) all the documents to be sent, rightclick and send to; Result: only one document was attached.
Second try: With all documents open in Word, click Open, select the same documents, rightclick, send to; Result: only one document was attached.

May be jscher2000’s solution of creating a macro is the only way?

Bjorn

Reply | Quote

Well, both operations you explain work fine for me in Word 2002 AND Word 97: all docs — I tested with 3 —
attached no problem.

Something else is wrong. I vaguely recall a setting, possibly in the Registry that makes this work. Give
me some time.

If it works for me, it works….

Reply | Quote

Hi Bjorn:
This works for me in Word 2000 & should work in 2002. Have you installed the latest service pack? The only thing I could find that might be related is a problem sending multiple attachments if you didn’t have the latest service pack. See this article.
Cheers,

Reply | Quote

I think I was thinking of a control flag for the common dialog named OFN_ALLOWMULTISELECT.
But I doubt that is relevant here unless…

Do you have a document mgmt system in place?

Reply | Quote

Bjorn,

Try this:

1) In Windows Explorer, navigate to your Sent To folder.
a. Win2k: c:documents and settingsusernameSendTo
b. XP: I don’t know, same I think
c. NT: c:winntprofilesusernameSentTo

2) Create a new Mail Recipient “link”
a. Right-click white space and select new | Text document
b. Name this new document “Mail Recipient-KP.MAPIMail” (no quotes)
c. When prompted to change extension: YES
d. Close Explorer

3) Test your multiple attach operation again. This time SentTo “Mail Recipient-KP”.

Did it work?

Reply | Quote

Neat. Where did you find this? And what does the KP stand for? Can you name it anything you want as long as it has MAPIMail as the extension?

Later: Duh! KP are your initials, aren’t they?

Reply | Quote

Actually, KP is an old, cryptic, anglo-european semaphore for four fortunes
of fortitude. Used here, it forces the MAPI transmission to get in gear.

(yes, my initials. name the thing whatever you want)

If found this in KB article 182378. Article 234487 shows a second way (Outlook specific).

Reply | Quote

Thanks Kevin,
This is very good!

It works well when I select files on a file server (like my C-drive)

Yes we have a DMS, SharePoint Portal Server (SPPS) from Microsoft.

Selecting documents (files) from a SPPS Folder only one document is attached. So there may be another solution?
SPPS is a database and so the “files” showing in WinExpl is links to the document and not a document (file) as on the C-drive.

Where can I find info about: “the common dialog named OFN_ALLOWMULTISELECT”

(Its late night, will be back in 10 hrs.)

Bjorn

Reply | Quote

OFN_ALLOWMULTISELECT is a flag, meaning it is a constant for some hex value
that tells the common dialog to allow selecting of multiple files.

I doubt there’s anything you can do about it unless you have access to code behind
any FileOpen dialog employed by your DMS. I know nothing of MS’s SPPS, so can’t
help you there.

Reply | Quote

(Edited by HansV to make URL into hyperlink by adding and – see Help 19)

Thanks Kevin
You have been of marvelous help. I got a big step forward and will try on MS D2D: http://www.msd2d.com/forums/ShowForum.aspx?ForumID=9%5B/url%5D

Though I haven’t got much help there it might be a good try.

Thanks a lot
Bjorn

Reply | Quote