Sending Email in Excel

  • Thread starter Thread starter bscarano
  • Start date Start date
B

bscarano

1.) I have a formula in a cell that when clicked, sends an email to
recipients in the formula. I have pasted the formula below. What I
want to do is put the date after the "End of Day: " part. However,
when you click on the link, it gives the serial representation of the
date if you use today(). Is there anyway to format so that is shows
the date formatted correctly?

In cell A1:
=HYPERLINK(CONCATENATE("mailto:P[email protected];
(e-mail address removed)?Subject=End of Day - ",A34,": Acc: ",AB1," for
","$",AA1," | Feats: ",'Enh Feats'!AA1," Data: ",'Enh Feats'!AB1," |
WO: ",AC1," | Take Rate: ",(AD1*100)," Percent"))

Returns:
End of Day - : Acc: 12 for $586 | Feats: 3 Data: 2 | WO: 45 | Take
Rate: 38 Percent

With recipients in To:

2.) I also want to change the " Percent" to an actual percent sign, but
everytime I try to change it, it blanks out the subject line.

3.) And finally, is there anyway to just send the email without
Clicking on the Send button in the email? I know you can utilize a
macro, but my company does not allow the Enable Macros options on some
computers.

Fester
 
Have you tried using the ASCII code for percent? It's ALT 037. You need
to use the keypad to type in the numbers.
 
for #1 (date):

=HYPERLINK(CONCATENATE("mailto:P[email protected];[email protected]"&
"?Subject=End of Day - ",TEXT(A34,"mm/dd/yyyy"),
": Acc: ",AB1," for ","$",AA1," | Feats: ",'enh feats'!AA1,
" Data: ",'enh feats'!AB1," |WO: ",AC1,
" | Take Rate: ",(AD1*100)," Percent"))

And for #2...

A long time ago, I read a tip in one of the local newspapers about site URLs
that look like:

www.aaaa.com/~namehere

The columnist didn't like using the tilde. It didn't show up in the article
correctly (newspaper printing problems??).

So someone wrote to him suggesting that he avoid the tilde altogether and use
%7E to represent the tilde. (% is the "escape" character and 7E is the ascii
code for ~)

For example, Mike Middleton's site is:

http://www.usfca.edu/~middleton/
or
http://www.usfca.edu/~middleton/

If you try clicking on both, you get to the same site.

So maybe, you could use the same idea:

=HYPERLINK(CONCATENATE("mailto:P[email protected];[email protected]"&
"?Subject=End of Day - ",TEXT(A34,"mm/dd/yyyy"),
": Acc: ",AB1," for ","$",AA1," | Feats: ",'enh feats'!AA1,
" Data: ",'enh feats'!AB1," |WO: ",AC1,
" | Take Rate: ",(AD1*100)," %25"))

I got this in Outlook Express (with not much in the fields):

End of Day - 02/16/2005: Acc: for $ | Feats: Data: |WO:
| Take Rate: 0 %
(one line, though)

But I also got this:
End of Day - 02/16/2005: Acc: for $ | Feats: Data: |WO:
| Take Rate: 0 %

Using:
=HYPERLINK(CONCATENATE("mailto:P[email protected];[email protected]"&
"?Subject=End of Day - ",TEXT(A34,"mm/dd/yyyy"),
": Acc: ",AB1," for ","$",AA1," | Feats: ",'enh feats'!AA1,
" Data: ",'enh feats'!AB1," |WO: ",AC1,
" | Take Rate: ",(AD1*100)," %"))

So it might be a difference with your email client.
 
Back
Top