Sorry if this was confusing. Here is an example of what is in the memo field:
***************************************
NAME ADDRESSLINE 1 ADDRESS LINE 2...
My company has a DB that has a memo field that is VERY long. Is there any way to adjust the display format of this field. As of right now I am trying the following:
Mid([LONG_MEMO_FIELD],1,65), Mid([LONG_MEMO_FIELD],66,65), Mid([LONG_MEMO_FIELD],131,65), Mid([LONG_MEMO_FIELD],196,65). But...
Remou,
Thanks so much for responding. Sorry about the VBA, thought I had put that A in there.
Withe the DoCmd.SendObject doesn't that send it as an attachment? I would prefer that the data not be presented in attachment form but body of the email.
I am attempting to write some VB code that will look at a table and extract the following elements, Associate Email, Associates Name, Reference Number, Amount, Days outstanding, and Managers Email, from a table. Then I would like access to send an email to the Associate with a CC to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.