mailto problem - too many characters gives #VALUE error

**lplaforest** · 12-03-2012, 11:58 AM

Hi guys,

I've ran into a little problem here.

Here's a formula I use to send emails to recipients depending on a situation :

=HYPERLINK("mailto:"&G3&subject=ALERT 3185&body=CALL%20TYPE%20%3A%0A%E2%80%A2%09"&C3&"%0A%0ASHOP%20%3A%0A%E2%80%A2%09"&D3&"%0A%0AAGENT%20%3A%0A%E2%80%A2%09"&F3&"%0A%0AFILE%20%3A%0A%E2%80%A2%09"&E3&"%0A%0ACOMMENTS%20%3A%0A%E2%80%A2%09"&I3&"%0A&", "OUTBOUND")

G3 (mail to) = [email protected]

C3 (Call Type) = intern, outbound or Service Center

D3 (Shop #) = #### - a four digits number representing one of our shops

F3 (Agent) = an agent name - could be any number of characters depending on lenght of name

E3 (File) = ###### - a 7 digits file number

I3 (Comments) = any comment the user wish to send concerning this file

The problem I have is that when I enter the info in my excel spreadsheet, at one point the OUTBOUND button switches to #VALUE error, and I guess it's because of how many characters the link can manage...

How can I resolve this using the same mailto method, I would like the automatic generated emails to have all the info I enter in the spreadsheet

Thanks a lot guys

**dilipandey** · 12-31-2012, 08:19 AM

HI lplaforest,

Do you use HYPERLINK function to send emails? can you share a example where it worked and then I can research why above one is not working ? thanks.

Regards,
DILIPandey
<click on below * if this helps>