SOLVED

Is that possible to add attachment in hyperlink formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-2904692%22%20slang%3D%22en-US%22%3EIs%20that%20possible%20to%20add%20attachment%20in%20hyperlink%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904692%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DHYPERLINK(%22mailto%3A%22%26amp%3BG2%26amp%3B%22%3Fsubject%3DTest%20Mail%22%26amp%3B%22%26amp%3Bbody%3DThis%20is%20Test%20Mail%22%2C%22Send%20Emails%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20add%20attachment.%20Is%20that%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2904692%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2904989%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20that%20possible%20to%20add%20attachment%20in%20hyperlink%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904989%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%2C%20the%20mailto%3A%20protocol%20does%20not%20support%20adding%20an%20attachment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905812%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20that%20possible%20to%20add%20attachment%20in%20hyperlink%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905812%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20other%20way%20to%20add%20attachment%3F%20(Or)%20Suggest%20me%20any%20other%20way%20to%20send%20email%20with%20attach.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20Excel%202016.%20VBA%20is%20Preferred.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super Contributor

 

 

=HYPERLINK("mailto:"&G2&"?subject=Test Mail"&"&body=This is Test Mail","Send Emails")

 

 

 

I want add attachment. Is that possible?

4 Replies

@Logaraj Sekar 

No, the mailto: protocol does not support adding an attachment.

@Hans Vogelaar ,

 

Is there any other way to add attachment? (Or) Suggest me any other way to send email with attach.

 

Using Excel 2016. VBA is Preferred.

 

In German Manufacturing, the technical word used to indicate an action(s} take accumulated blinks or blinks of the eye. From these movements, costs of manufacturing in time and money are determined.

All of us waste thurblicks on a variety of unnecessary actions such as “delete”, “Spam”, “Junk” &, “block sender”.

I receive 200 to 500 annoying emails a day, many of them day after day from the same advertiser.

I explained to the BIG M how to provide a quick delete email and preserve email in micro seconds.

They failed at every attempt.

Here is the logic if anyone can do it.

Outlook is organized in domains,

When one invokes it, all incoming fall into a date specific domain.

Generally, email of importance hover around 10%

The Date is defined a “Today”

Under the Wilbur Macro”

Of one day or a myriad of days, click only on those wanted saved,



Assume that we click only one item. This indicates “SAVE” on each item selected.

Any that are not selected go to “Potters Field” These are future blockers of incoming unwanted mail and stored. They may also be bloked in bulk.

Now only the save appear,

After Reading the Saves, any can be sent to Potters Field individually

After the Saves are done, they are sent to the “Afterlife”, If they ever come in again, they are automatically saved so they come up behind the last one already saved,

List cuts eliminates all junk everyday, saves conversations







best response confirmed by Logaraj Sekar (Super Contributor)
Solution

@Logaraj Sekar 

You can send any open workbook as attachment using the SendMail method of the Workbook object, for example:

Sub SendActiveWorkbook()
    ActiveWorkbook.SendMail Recipients:="emailaddress", Subject:="Monthly Report"
End Sub

If you want to add other files, you can use Automation to send a message using Outlook. For example:

Sub SendWithAttachment()
    Dim objOL As Object
    Dim objMail As Object
    Set objOL = CreateObject("Outlook.Application")
    objOL.Session.Logon
    Set objMail = objOL.CreateItem(0)
    With objMail
        .To = "Someone"
        .CC = "Another"
        .Subject = "Monthly Report"
        .Body = "Please see the attached report"
        .Attachments.Add "PathAndFilename"
        ' Use only ONE of the following two lines
        .Display ' to inspect the message bedore sending it
        .Send ' to send the message immediately
    End With
End Sub