I had data set up as MailTo hyperlinks. I broke up a large table into
three tables but discovered all the MailTo hyperlinks are now just web
address hyperlinks. Opening up Outlook by selecting the hyperlink is
very useful.
I found some vba code for an Excel macro that works well but am unsure
within Access 2003 what to do.
Sub test()
Dim mycell As Range
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

Any suggestions?

On Dec 1, 9:59*pm, Duncan <dunca... (AT) optusnet (DOT) com.au> wrote:
***Sorry meant to say Ron de Bruin had written the code I found.
I copied all the email addresses into a spreadsheet and the macro did
its magic converting to mailto hyperlinks BUT when I copied it back
into the access table the mailto part was missing. Back to square one.
Duncan