UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Outlook Mailitem - How To Assign To The Body Property A Memo Field With 255 Characters And More, Access 2010    
 
   
informer
post Jan 3 2018, 04:34 AM
Post#1



Posts: 222
Joined: 18-May 16
From: Toulon - South France


Hi

In a VBA function, I assign to the body property of Outlook object a memo field

CODE
.Body = recSet!eMailComment '-> Memo field


But its content is cut off after 255 characters.

Is there a solution to circumvent this restriction?

Thanks by advance for your help


--------------------
When a wise man points at the moon the imbecile examines the finger
(conficius 551 BC - Death 479 BC)
Go to the top of the page
 
cheekybuddha
post Jan 3 2018, 10:07 AM
Post#2


UtterAccess VIP
Posts: 10,141
Joined: 6-December 03
From: Telegraph Hill


This is probably due to the query used in your recordset truncating the memo field.

See Allen Browne for causes/solutions

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
informer
post Jan 4 2018, 03:59 AM
Post#3



Posts: 222
Joined: 18-May 16
From: Toulon - South France


Thanks a lot cheekybuddha for your help. As soin as I’ll apply Allen Brown solution, I’ll post my feedback

--------------------
When a wise man points at the moon the imbecile examines the finger
(conficius 551 BC - Death 479 BC)
Go to the top of the page
 
cheekybuddha
post Jan 4 2018, 08:35 AM
Post#4


UtterAccess VIP
Posts: 10,141
Joined: 6-December 03
From: Telegraph Hill


yw.gif

Keep us posted as to your progress.

thumbup.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 
informer
post Jan 4 2018, 10:54 AM
Post#5



Posts: 222
Joined: 18-May 16
From: Toulon - South France


Hi cheekybuddha,

It works great now

I applied recommendations provided by Allen’s Browne :
  1. Move on first position the memo field
  2. remove DISTINCT SQL command and change my query to select only one record by using SELECT memoField,.... FROM tblX WHERE tblX.id IN ( SELECT DISTINCT tblX.id FROM....).

Thanks a lot again cheekybuddha.

PS: what does it happen if there is more than one memo field?

--------------------
When a wise man points at the moon the imbecile examines the finger
(conficius 551 BC - Death 479 BC)
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th July 2018 - 06:31 PM