timamartin
asked on
Mailing a report but the subject field is too small Microsoft Access 2007
I have some reports that get emailed to employees, but the subject field is too small. I am using a macro as shown below. What options do I have to allow me to increase the body text in the email? Create a variable and print that?
snap01018.jpg
snap01018.jpg
ASKER
I have created a table with miscellaneous text strings to use here and there. Is it possible to reference that table and that record in the subject line of the send mail dialogue?
I wasn't sure how to do the unbound text box deal.
I wasn't sure how to do the unbound text box deal.
timamartin,
You can reference a table using DLookup, or a field on your form using =Forms!FormName!TextboxNam e
Regards,
Patrick
You can reference a table using DLookup, or a field on your form using =Forms!FormName!TextboxNam
Regards,
Patrick
ASKER
So how would I put this into the Subject line in the send mail?
=IIf([Form].[Description]. [TextForma t]=1,Plain Text([Desc ription]), [Descripti on])+=DLoo kup[Stext] , "Strings", "ID = 1"
Table = Strings
Field = Stext
Record = 1
BTW the last programming I did was using QBasic - a compilable version of BASIC!!
=IIf([Form].[Description].
Table = Strings
Field = Stext
Record = 1
BTW the last programming I did was using QBasic - a compilable version of BASIC!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your Welcome
;-)
;-)
Why not simply add an unbound textbox to your form for people to enter/edit the subject line? You can start
that textbox with default text, and allow edits/additions as needed...
Regards,
Patrick