Hi Jupiter Jim

A csv file is a txt file so there is no formatting.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jupiter Jim" wrote in message ...
You're a friggin genius, but one more question. I was doing that to import
the info into a Palm Pilot, which only recognizes .csv and .txt files. It
doesn't seem that the e-mail addresses stay intact when saved as a .csv
file...any further suggestions??

"Ron de Bruin" wrote:

You can use a macro

this example change all mail addresses to links in column B

Sub test()
For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s)
If myCell.Value Like "?*@?*.?*" Then
ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value
End If
Next
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jupiter Jim" <Jupiter wrote in message ...
When copying and pasting an e-mail address into excel it does not appear as,
or export as, an e-mail address. However, when I type the same address in a
cell it appears as and acts as an e-mail address. Is there a way I can
change a group of imported cells that contain e-mail addresses into active
e-mail addresses???


"Ron de Bruin" wrote:

Everything is possible Paul (almost)

After you try example 2 post back

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"phocused" wrote in message ...
Ron,

Will try this out tomorow at work, many thanks. I hope you dont mind my
picking your brain like this but i have further questions.

Is it possible to have multiple conditions data to one recipient. So 1
person may be responsible for multiple updates but not all on the same day.
So he may have 1 yes today and 3 no's, 3 yes's tommorow and 1 no and so on.
How do i set this, do i need a matrix of some description.

Also

IS it possible to have the mail sent as a single mail to multiple recipients
or does it have to be 1 mail per name on the list?

Rgds Paul

"Ron de Bruin" wrote:

There is also a example on the same webpage
http://www.rondebruin.nl/mail/folder3/message.htm

Example 2

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Hi Paul

You can add for example "Send" in another column with code when you have send the mail
and test this value in the macro

If cell.Value Like "?*@?*.?*" And LCase(cell.Offset(0, 1).Value) = "yes" And cell.Offset(0, 2).Value = "" Then

Then before <Set OutMail = Nothing insert a value in the cell

cell.Offset(0, 2).Value = "send"
Set OutMail = Nothing


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"phocused" wrote in message
...
Ron,

Thanks for this, it worked like a dream. I have a further question. Is there
a way to make it run once only ? Make it send the mails when the condition is
yes. Reset the 'Yes' to 'No' and sned a copy of itself (the whole workbook)
to another list of addresses.

Let me explain further.

At the moment the trigger is for me to manually run the macro. I would like
this to work dynamically if possible.
If it is dynamic then the issue here would be that I then send the report
out to senior management and i dont want the macro running for every incident
of the report opening.

Does that make any sense :-)

rgds Paul and thanks again for your help

"Ron de Bruin" wrote:

Hi phocused

You can add a formula that display yes in a column if it is one day before the problem next update date
Date column = for example B

=IF(TODAY()=B1-1,"yes","no")
and copy down

Then if you run this macro every day it will create the mails for you
http://www.rondebruin.nl/mail/folder3/message.htm

post back if you have problems


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"phocused" wrote in message
...
Hi, hopefully someone can help me, i have searched the forums but not sound
anything that fits.

I have a spread sheet which has a problem ref, prob description, prob owner,
prob next update date fields

I review the problems each morning with the owners and update the
spreadsheet then send it out.

what i would like to do is on the day before the problem next update date,
send the owner a mail notifying him that he needs to attend the meeting the
following morning and he will need to provide and update.

Is this possible?

Rgds Paul