Outgoing mail format = HTML.
Using Outlook XP, Access 97 on a Win2k machine
(also tested on an XP machine w/ Outlook XP, with this database as a runtime install):
I am creating the body of the email message by accumulating items into a text variable.
This has the same basic format as orders/invoice.
Basically, I get several items per person.
Each item has two pieces — the topic title, and the link to that topic.
My Link is a link field in the table, and I double-click on it, and go to the proper place (working link).
I loop to get the two pieces of each item into one line:
Do While current_user = loop_user
listglom = listglom & Chr$(13) & Chr$(10) & myset!Topic & Chr(9) & HyperlinkPart(myset!TopicDoc, acAddress)
— etc — (er, I do know vbCRLF)
Loop ‘while current_user etc
‘ No longer current_user, fall out & send
Set itm = appOutlook.CreateItem(olMailItem)
With itm
.To = ToEdress
.Subject = subjline
.Body = introWords & listglom & sigblock
.BodyFormat = olFormatHTML
.Save
End With
Set itm = Nothing
– The link does not highlight or underline as a link, which I was afraid would happen since it was a text string, although I have HTML formats designated.
– _but_ if I just go to the end of the item line, and hit the space bar, the item becomes underlined and highlighted — _but_ it still fails to act as a link.
Anyone have any clues?
thx
Pat W.
