I set up a database from an existing Excel table containing email addresses. The database definition of the field was hyperlink.
I have written some Visual Basic to produce an email to be sent to all addresses on the database. It's quite complex with personalised attachments. When I ran the code to send the emails, most were sent but some failed due the fact that the email address was a hyperlink and Outlook tried to send to addresses starting with 'Mailto:'
I am not sure how to overcome this. Some of the email addresses are pure text with no hyperlink capabilities i.e I cannot click on the field and get Outlook to open. These work with my VB code. the genuine hyperlink formatted addresses do not. What I need is to be able to convert them all to pure hyperlink format or to pure text. Changing the field type to text adds a whole new character string. Changing it back to hyperlink doesn't work either!
Can anyone help?
I have written some Visual Basic to produce an email to be sent to all addresses on the database. It's quite complex with personalised attachments. When I ran the code to send the emails, most were sent but some failed due the fact that the email address was a hyperlink and Outlook tried to send to addresses starting with 'Mailto:'
I am not sure how to overcome this. Some of the email addresses are pure text with no hyperlink capabilities i.e I cannot click on the field and get Outlook to open. These work with my VB code. the genuine hyperlink formatted addresses do not. What I need is to be able to convert them all to pure hyperlink format or to pure text. Changing the field type to text adds a whole new character string. Changing it back to hyperlink doesn't work either!
Can anyone help?
