Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Conas ríomhphost a sheoladh ó Excel le feidhm hipearnasc mailto?

In Excel, is féidir leat an fheidhm hipearnasc mailto a úsáid chun ríomhphost a chruthú ó Excel. Cuimsíonn an ríomhphost a chruthaigh hipearnasc mailto seoladh ríomhphoist, ábhar agus comhlacht an fhaighteora. San Airteagal seo, taispeánfaimid duit conas ríomhphost a sheoladh ó Excel le feidhm hipearnasc mailto.

Seol ríomhphost ó Excel le feidhm hipearnasc
Seol ríomhphost ó Excel le feidhm hipearnasc
Seol r-phost go héasca trí Outlook bunaithe ar liosta seoltaí cruthaithe le Kutools for Excel


Seol ríomhphost ó Excel le feidhm hipearnasc

Sa chuid seo, taispeánfaidh mé duit conas hipearnasc mailto a chruthú go díreach in Excel. Déan mar a leanas le do thoil.

1. Ar dtús, ní mór duit seoladh an fhaighteora, ábhar ríomhphoist agus an comhlacht ríomhphoist a iontráil ar leithligh i gcill B1, B2 agus B3. Féach an pictiúr.

2. Roghnaigh cill bhán a theastaíonn uait a aimsíonn an hipearnasc mailto inti, mar shampla cill B4.

3. Cóipeáil agus greamaigh an fheidhm hipearnasc = HYPERLINK ("mailto:" & B1 & "? Subject =" & B2 & "& body =" & B3, "Ag nascadh téacs") isteach i mBarra Foirmle na cille roghnaithe, agus ansin brúigh an Iontráil eochair.

nótaí: San fhoirmle, tá seoladh, ábhar ríomhphoist agus comhlacht an fhaighteora i B1, B2 agus B3; agus is é an “téacs nasctha” téacs taispeána an hipearnasc seo. Is féidir leat iad a athrú de réir mar is gá duit.

As seo amach, nuair a chliceálann tú an hipearnasc mailto, cruthófar r-phost Outlook go huathoibríoch leis an bhfaighteoir, ábhar agus comhlacht sonraithe. Féach an pictiúr:


Seol ríomhphost ó Excel le feidhm hipearnasc

Toisc go bhfuil carachtair an mhodha thuas teoranta, seo isteach modh anther duit chun hipearnasc mailto a chruthú in Excel.

1. Roghnaigh cill ar mhaith leat hipearnasc mailto a chruthú.

2. cliceáil Ionsáigh > Hyperlink. Féach an pictiúr:

3. Sa Cuir isteach Hyperlink bosca dialóige, ní mór duit:

1). Cliceáil Seoladh Ríomhphoist sa Nasc le pána;

2). Clóscríobh seoladh ríomhphoist an fhaighteora isteach sa Seoladh r-phoist bosca;

3). Sa ábhar bosca, clóscríobh san ábhar ríomhphoist, tar éis an t-ábhar ríomhphoist a chlóscríobh, iontráil & comhlacht = comhlacht ríomhphoist;

Mar shampla, más “ábhar an ríomhphoist” an t-ábhar ríomhphoist agus más “corp an ríomhphoist” an comhlacht ríomhphoist, iontráil le do thoil ábhar an ríomhphoist & an choirp = comhlacht an ríomhphoist isteach sa ábhar bosca.

4). Cliceáil ar an OK cnaipe. Féach an pictiúr:

Ansin cruthaítear an hipearnasc mailto. Cliceáil air, cruthófar r-phost Outlook le seoladh, ábhar agus corp gach faighteora sonraithe liostaithe.


Seol r-phost go héasca trí Outlook bunaithe ar liosta seoltaí cruthaithe le Kutools for Excel

Molfaidh an chuid seo an Seol Ríomhphost fóntais de Kutools le haghaidh Excel. Leis an bhfóntas seo, is féidir leat ríomhphoist a sheoladh go héasca le liosta postála sonraithe a chruthaigh tú in Excel. Déan mar a leanas le do thoil.

Roimh iarratas a dhéanamh Kutools le haghaidh Excel, Le do thoil é a íoslódáil agus a shuiteáil ar dtús.

1. Ar dtús, ní mór duit liosta seoltaí a theastaíonn uait a chruthú in Excel. Cliceáil Kutools Plus > Cruthaigh Liosta Ríomhphoist. Féach an pictiúr:

2. Sa Cruthaigh Liosta Ríomhphoist bosca dialóige, seiceáil le do thoil na réimsí a chaithfidh tú a áireamh sa ríomhphost sa dá cheann Colúin le haghaidh liosta seoltaí agus Ceangail comhaid ailt. Sonraigh suíomh chun an liosta seoltaí cruthaithe a chur agus ansin cliceáil ar an Cruthaigh cnaipe. Féach an pictiúr:

3. Anois cruthaítear liosta seoltaí samplach. Líon isteach na réimsí comhfhreagracha leis an ábhar atá uait mar atá thíos an pictiúr a thaispeántar:

4. Roghnaigh an liosta Ríomhphoist ar fad, ansin cliceáil Seol Ríomhphost cnaipe sa ribín. Féach an pictiúr:

5. Sa Seol Ríomhphost bosca dialóige, is féidir leat a fheiceáil go bhfuil gach réimse líonta leis an ábhar comhfhreagrach ar an liosta postála, cum an comhlacht ríomhphoist de réir mar is gá duit, seiceáil an Seol ríomhphoist trí Outlook bosca, agus ar deireadh cliceáil ar an Seol cnaipe chun an ríomhphost a sheoladh. Féach an pictiúr:

6. Ina dhiaidh sin, a Kutools le haghaidh Excel tagann bosca dialóige suas chun insint duit faoi sheoladh an ríomhphoist, cliceáil ar an OK cnaipe agus dún an bosca dialóige Seol Ríomhphoist.

Anois is féidir leat dul chuig fillteán Seol Míreanna Outlook chun an ríomhphost seolta a sheiceáil. Féach an pictiúr:

  Más mian leat triail saor in aisce (30 lá) a bheith agat ar an bhfóntas seo, cliceáil le do thoil chun é a íoslódáil, agus ansin téigh chun an oibríocht a chur i bhfeidhm de réir na gcéimeanna thuas.


Seol r-phost go héasca trí Outlook bunaithe ar liosta postála cruthaithe in Excel le Kutools le haghaidh Excel


Airteagal gaolmhar:


Na hUirlisí Táirgiúlachta Oifige is Fearr

Réitíonn Kutools for Excel an chuid is mó de do chuid Fadhbanna, agus Méadaíonn sé do Tháirgiúlacht 80%

  • Athúsáid: Cuir isteach go tapa foirmlí casta, cairteacha agus aon rud a d'úsáid tú roimhe seo; Cealla a Chriptiú le pasfhocal; Cruthaigh Liosta Ríomhphoist agus seol ríomhphoist ...
  • Barra Foirmle Super (cuir línte iolracha téacs agus foirmle in eagar go héasca); Leagan Amach Léitheoireachta (líon mór cealla a léamh agus a chur in eagar go héasca); Greamaigh go dtí an Raon Scagtha...
  • Cumaisc Cealla / Sraitheanna / Colúin gan Sonraí a chailleadh; Ábhar Cealla Scoilt; Comhcheangail Sraitheanna / Colúin Dúblacha... Cill Dúblach a Chosc; Déan comparáid idir Ranganna...
  • Roghnaigh Dúblach nó Uathúil Sraitheanna; Roghnaigh Blank Rows (tá na cealla uile folamh); Aimsigh Super agus Fuzzy Aimsigh i go leor Leabhar Oibre; Roghnaigh go randamach ...
  • Cóip Díreach Cealla Il gan tagairt fhoirmle a athrú; Tagairtí Cruthaigh Auto chuig Bileoga Il; Cuir Urchair isteach, Boscaí Seiceála agus go leor eile ...
  • Sliocht Téacs, Cuir Téacs leis, Bain de réir Poist, Bain Spás; Subtotals Paging a chruthú agus a phriontáil; Tiontaigh Idir Ábhar Cealla agus Tráchtanna...
  • Scagaire Super (scéimeanna scagaire a shábháil agus a chur i bhfeidhm ar bhileoga eile); Ard-Sórtáil de réir míosa / seachtaine / lae, minicíocht agus níos mó; Scagaire Speisialta le cló trom, iodálach ...
  • Comhcheangail Leabhair Oibre agus Bileoga Oibre; Cumaisc Táblaí bunaithe ar eochaircholúin; Roinn Sonraí i Ilbhileoga; Baisc Tiontaigh xls, xlsx agus PDF...
  • Níos mó ná 300 gné chumhachtach. Tacaíochtaí Office / Excel 2007-2019 agus 365. Tacaíonn sé le gach teanga. Imscaradh éasca i d’fhiontar nó d’eagraíocht. Gnéithe iomlána triail saor in aisce 30 lá. Ráthaíocht ar ais airgid 60 lá.
cluaisín kte 201905

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
bun officetab
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    jamievo · 1 years ago
    Is it possible to have a hyperlink of the file path of the workbook itself generated in the body of the email?
  • To post as a guest, your comment is unpublished.
    Rach · 2 years ago
    Hi, for the attachment, can it be any type of documents eg word, pdf? how much is your fee if I only want to send mass emails from excel spreadsheet?
  • To post as a guest, your comment is unpublished.
    Trial version user · 3 years ago
    Hello, as per the auto-emailing component, is it possible to have a fixed Subject and a fixed Body? In other words I want to send emails without typing anything.
    • To post as a guest, your comment is unpublished.
      Chadd · 2 years ago
      I just figured out two work arounds for this trial version user
      method 1) is to choose a cell that's outside your data and enter the fixed text there. A1 is the cell I chose for my example. in the formula you just need $ in front of the cell letter and number so it always will go to that cell no matter where you copy the formula to. (shown below in the fixed subject)
      method 2) type the fixed info right in your formula with quotes example is the fixed body below

      example: =HYPERLINK("mailto:" & B1 & "?subject="& $A$1 & "&body="&"fixed body","AutoEmail")
    • To post as a guest, your comment is unpublished.
      crystal · 3 years ago
      Good Day,
      This function does not take into account right now yet. Thank you for sharing.
  • To post as a guest, your comment is unpublished.
    Gustavo · 3 years ago
    The body I'm using is a formula =concatenate(b5,b6,b7,b8) and it gives my a #value error. Is there a work around to use formulas?
    • To post as a guest, your comment is unpublished.
      Chadd · 2 years ago
      yes I just figured out the work around for this Gustavo. example: =HYPERLINK("mailto:" & B1 & "?subject="& B2 & "&body=" & B5&" "&B6&" "&B7&" "&B8&", "Linking text")

      im having an issue with the linking text to display afterwards, but other than that it works perfectly.
    • To post as a guest, your comment is unpublished.
      crystal · 3 years ago
      Dear Gustavo,
      Sorry can't solve this problem.
  • To post as a guest, your comment is unpublished.
    EmDee · 3 years ago
    I love this function!My only issue is that if B4 is formatted as a date, outlook does not see it as such. (example if 10-Dec-17 = 402368")I'd love to find a work around for this! My B4 has conditional formatting, which requires the formatting to stay as is.
    • To post as a guest, your comment is unpublished.
      EmDee · 3 years ago
      Correction: Cell B3 - Sorry (Body of email)
      • To post as a guest, your comment is unpublished.
        crystal · 3 years ago
        Sorry Mike,
        Can't solve this problem.
  • To post as a guest, your comment is unpublished.
    Mike · 3 years ago
    I love this function! My only issue is that if B4 is formatted as a date, outlook does not see it as such. (example if 10-Dec-17 = 402368")

    I'd love to find a work around for this! My B4 has conditional formatting, which requires the formatting to stay as is.
  • To post as a guest, your comment is unpublished.
    Rishi Raj · 3 years ago
    Thanks a lot its very helpful feature u describe here apart from that can we create a shortcut of attachment.
  • To post as a guest, your comment is unpublished.
    setu · 3 years ago
    how can i add another body in excel cell with your formula
    • To post as a guest, your comment is unpublished.
      crystal · 3 years ago
      Dear setu,

      If you need to add another body in cell with this formula, please add this body cell into the body section and separate these two bodies by a seperator as you need: =HYPERLINK("mailto:"&B1&"?subject="&B2&"&body="&B3 &" "&B4,"Linking text"). See screenshot:
      • To post as a guest, your comment is unpublished.
        TIFFANI JONES · 3 years ago
        Hello,

        This was very helpful, I have one question, is there a way to create the body of the email such that B3 and B4 would be on their own separate line w/in the body of the email and not on one line? Make sense? I would like the feature to be such that it was like I pressed enter after B3 and B4 starts a new line.
  • To post as a guest, your comment is unpublished.
    Ian · 3 years ago
    Is there a formula to send the current worksheet or book as an attachment to a recipient?
    Regards
    Ian
    • To post as a guest, your comment is unpublished.
      CHRIS · 3 years ago
      Ian, as far as I know there is no attachment option in 'mailto:' syntax. It supports only aditional 'cc', 'bcc', 'subject' and 'body' fields.
      • To post as a guest, your comment is unpublished.
        Vance · 3 years ago
        There is, it is the Attachment= but, unfortunately, like you I have not found a way to include the current spreadsheet using it. You can use a Macro, but it only seems to work with Outlook:
        Sub Email_Excel_Button()
        ActiveWorkbook.SendMail Recipients:="you@there.com", Subject:="Spreadsheet"
        End Sub
  • To post as a guest, your comment is unpublished.
    Chris · 3 years ago
    I think there is some limitation in 'body=' string length that causes the '#ARG' error. Try to shorten the string.
  • To post as a guest, your comment is unpublished.
    Rutva · 3 years ago
    When i try to add email body in cell, it gives me error. How can it be resolved ?
  • To post as a guest, your comment is unpublished.
    Rutva · 3 years ago
    =HYPERLINK("mailto:" & B7 & "?subject="& B8 & "&body=" & B9 & "body=" & B10 & "body=" & B11 & "body=" & B12, "Linking text")

    What if we want to add multiple lines in body ? I tried above formula but did not worked. Please help
  • To post as a guest, your comment is unpublished.
    Will · 3 years ago
    Great post. However, it will not work when I write 2017-2018 Insurance Invoices in the subject. If I simply write Insurance Invoices it works. Is there a limitation or a workaround solution? Thanks.
    • To post as a guest, your comment is unpublished.
      Paul · 3 years ago
      Will, you are leading with numbers that you intend to use as text so just insert an apostrophe before the number. (ex: '2017-2018 Insurance Invoices.)
  • To post as a guest, your comment is unpublished.
    Riz · 4 years ago
    Hi, how can i send a complete table to email body using hyperlink function in Excel 2013?
  • To post as a guest, your comment is unpublished.
    Riz · 4 years ago
    Hi All, is it possible to send a complete table in the body of the email using this function?
  • To post as a guest, your comment is unpublished.
    RF · 4 years ago
    Hi,

    I am using excel 2013, I have set up the e-mail link within excel. However when i click send the e-mail box pops up and requires me to click send manually. Is there a simple way or steps that I have to take in order to just click on the hyperlink and excel will automatically send the e-mail? And perhaps provide a confirmation that will log itself somewhere into the excel worksheet (so we know it's worked)?
  • To post as a guest, your comment is unpublished.
    Mark W · 4 years ago
    As above, Can you create an email with the workbook as an attachment?
  • To post as a guest, your comment is unpublished.
    Shez · 4 years ago
    Hi, thanks in advance for the help.
    Can you create an email with the workbook as an attachment?
    basically create a mailto hyperlink that creates an email with the workbook as an attachment, from the same workbook.
  • To post as a guest, your comment is unpublished.
    ANAND KUMAR · 4 years ago
    Thanks Alan ☺.........It did work.
  • To post as a guest, your comment is unpublished.
    Alan F. · 4 years ago
    =HYPERLINK("mailto:"&B1&"?subject="&B2&"&body="&B3&"&cc="&B4&"& A5","Email To Someone")
    where b4 is in the format someone@somewhere.com;someonelese@somewhereelse.com
  • To post as a guest, your comment is unpublished.
    Curtis · 4 years ago
    This does not work, at least with Office 2016. The created link places the cell reference in the To filed of the email opened in Outlook rather than the email address. In the example used, the email will be addressed to B1 rather than the content of cell B1.
  • To post as a guest, your comment is unpublished.
    Anand Kumar · 4 years ago
    How can we add CC and BCC column there. Please explain.