Try again: Using mail-to hyperlink with an attachment

[Hall]

I'm creating forms using Excel and Word. Somewhere in the form is an email
address. I can use Edit-hyperlink to specify the recipient address of the
email address as well as the subject field. Great.

What I'd really like is to be able to specify that the form file itself (the
..doc or .xls) is also attached to the email message. I'd like to specify
that right in the hyperlink.

Then it can act as a workflow.

I don't know anything about VBA so I'd rather not go there.

Is this possible?

 

[broro183]

Hi Hall,

No, I don't think it is possible without some amount of VBA - I could
be wrong though.

Here are a couple of links involving the use of VBA which you may find
helpful as they explain the VBA they use:

http://www.rondebruin.nl/sendmail.htm
(contains a # of useful links)

http://j-walk.com/ss/excel/tips/tip86.htm
(shows how to send bulk emails which contain content from the
spreadsheet)

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[CyberTaz]

I'm not sure I understand what you are asking for, but perhaps I'm on the
right track?

When you go into the Edit/Insert Hyperlink dialog box, the Text to Display
field can be changed to read as whatever you wish. That's how it will appear
in the doc, but it will still link to the specified target (email addy, URL,
etc.).

Also, the Screen Tip button gives you access to a field where you can enter
text to appear in a yellow Tip Box (which shows up when the mouse hovers on
the link) rather than the target information that appears by default.

If these ideas won't satisfy your need, try to be a bit more specific with
what you are actually looking for.

 

[Hall]

OK, I'll try to be more specific.

I want the hyperlink to be in a file. When the user clicks on it, its is
like clicking on File->Send-to->Mail Recipients (as attachment), and with
the To field filled in.

Basically, when I click on this link, this same file gets sent as an
attachment to a pre-specified recipient address. All I'd have to do as a
user is click on the link and then click on the send button of the new
message. Its to make sending the file (which is a form) be as bullet proof
as possible.

The business context for this is its a form and I want to effectively have a
workflow feature.

Thanks!

 

[CyberTaz]

AFAIK, a hyperlink, alone, will not do this - it simply points to a 'target'
of some sort. In this case, the email message is the target, but attaching
the form to the email is a separate & distinct action. Likewise, the
File>Send To command is designed to attach the doc, but not to pre-address
the email.

Also, Word is not the email client. It is simply calling Outlook or whatever
email program the user works with, and attachments are handled by *that*
software.

I'm not sure about how you need to proceed, but I am rather certain that
some degree of code will be required.