Link to home
Start Free TrialLog in
Avatar of timamartin
timamartinFlag for United States of America

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
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Hello timamartin,

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
Avatar of timamartin

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.
timamartin,

You can reference a table using DLookup, or a field on your form using =Forms!FormName!TextboxName

Regards,

Patrick
So how would I put this into the Subject line in the send mail?

=IIf([Form].[Description].[TextFormat]=1,PlainText([Description]),[Description])+=DLookup[Stext], "Strings", "ID = 1"


Table = Strings
Field = Stext
Record = 1

BTW the last programming I did was using QBasic - a compilable version of BASIC!!
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Your Welcome
;-)