HTML body in Access 2007

[amangupts]

Hi,

I am trying to send an email message through Access 2007 with the use of Outlook 2007. I have used .HTMLBody = "Please find attached Payslip". This part is functioning fine. I am trying to insert Dear Employee Name as header and Regards, Finance Team as Footer. Kindly guide me how to achieve this.

Secondly is there a way to make a number bold in HTML body? For text we can use <b> and </b> tags. Are there any tags to make a value/number bold in HTML body.



Thanks in Advance
Aman

[boblarson]

1. Your HTML Body needs to use HTML if you want anything other than normal text.

2. Data can be made bold by using the same tags as you have mentioned.

3. Assuming you have a form which has the values you want (there can be other methods too but you didn't mention how you were geting the employee Name and such) this is an example:

Dim strBody As String
 
strBody = "Dear " & Me![Employee Name] & ": <br><br> Please find the attached Payslip. <br><br> The total is <b>" & Me!PayAmount & "</b><br><br>Regards<br><br><br>Finance Team"
 
.HTMLBody = strBody

(sorry for all of the <br> as HTML is not my strong suit and I'm sure there is a better way.)

[amangupts]

Hi,

Thanks a lot for your help. I am able to achieve what I wanted to. However I am still not able to make the Value bold. I am pasting the code, for your reference. I want Me.Period.Value to get bold (it is basically a combination of month and year as March'2012.

strBody = "Dear " & Me!EmpNam.Value & ",<br><br><br> Please find attached <b>Payslip</b> for the Month of " & Me.Period.Value & "." & " " & "In case of any discrepancy, kindly report the issue to the <b>Finance Department</b>.<br><br><br>Regards<br><br>Finance Team"

Kindly help me in getting this field bold.

Regards,
Aman

[boblarson]

strBody = "Dear " & Me!EmpNam.Value & ",<br><br><br> Please find attached <b>Payslip</b> for the Month of <b>" & Me.Period.Value & "</b>." & " " & "In case of any discrepancy, kindly report the issue to the <b>Finance Department</b>.<br><br><br>Regards<br><br>Finance Team"

[amangupts]

Hi,

Thanks a lot for all the help. I am able to achieve the exact results with the solutions provided by you.

Once again thanks a lot.

Regards,
Aman