Hello
I am new to the forum & have been dabbling in Access & VBA for a couple of years!
I have a question please:
I currently have a DB which works ok & also exports data into Outlook
In the strEmailmsg I have a long string which looks up data from several table columns & then adds new line after each piece of data (see below)
"Other Information Reported:" & vbNewLine & vbNewLine & [SiteNotes] & vbNewLine & [SiteNotes-Line2] & vbNewLine & [SiteNotes-Line3]&_
I would like NOT to add new line if no data present but move onto next [] data item?
Any suggestions please?
I am new to the forum & have been dabbling in Access & VBA for a couple of years!
I have a question please:
I currently have a DB which works ok & also exports data into Outlook
In the strEmailmsg I have a long string which looks up data from several table columns & then adds new line after each piece of data (see below)
"Other Information Reported:" & vbNewLine & vbNewLine & [SiteNotes] & vbNewLine & [SiteNotes-Line2] & vbNewLine & [SiteNotes-Line3]&_
I would like NOT to add new line if no data present but move onto next [] data item?
Any suggestions please?