Recipients.add not working when word set as email editor

[1DMF]

Hi,

How do you resolve the issue of using VBA to create a mail item and add recipients when using MS word as email editor.

I have the following...

Set oReceipt = .Recipients.Add(rs.Fields("EmailName"))
oReceipt.Type = olTo
l_Msg.Close (olSave)
l_Msg.Display

When the email opens, the TO field is blank?

It works fine if Word is not set as email editor.

How do I resolve this?

Thanks,
1DMF.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[PHV]

Why not simply this ?
l_Msg.To = rs!EmailName

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[1DMF]

because that's a simplified version of the code, it's dependent on whether the recipient should be in the 'TO' or it could be a whole bunch of BCC's

either way it doesn't show when word is used for email editing, works fine, when word is deselected?

Would you like to see the full code snippet?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts