PrinceCaspian
New Member
- Joined
- Apr 4, 2016
- Messages
- 5
Hi guys.
There is a certain VBA code i use to send emails to specific addresses. I want a particular text to be bold. can you help me please?
i want the following text to be bold:
Just the "required access" part.
There is a certain VBA code i use to send emails to specific addresses. I want a particular text to be bold. can you help me please?
Code:
Sub Send_Row_Or_Rows_Attachment_2()'Working in 2000-2016
'For Tips see: [URL]http://www.rondebruin.nl/win/winmail/Outlook/tips.htm[/URL]
Dim OutApp As Object
Dim OutMail As Object
Dim rng As Range
Dim Ash As Worksheet
Dim Cws As Worksheet
Dim Rcount As Long
Dim Rnum As Long
Dim FilterRange As Range
Dim FieldNum As Integer
Dim NewWB As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim FileExtStr As String
Dim FileFormatNum As Long
On Error GoTo cleanup
Set OutApp = CreateObject("Outlook.Application")
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
'Set filter sheet, you can also use Sheets("MySheet")
Set Ash = ActiveSheet
'Set filter range and filter column (column with e-mail addresses)
Set FilterRange = Ash.Range("A1:L" & Ash.Rows.Count)
FieldNum = 2 'Filter column = B because the filter range start in column A
'Add a worksheet for the unique list and copy the unique list in A1
Set Cws = Worksheets.Add
FilterRange.Columns(FieldNum).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Cws.Range("A1"), _
CriteriaRange:="", Unique:=True
'Count of the unique values + the header cell
Rcount = Application.WorksheetFunction.CountA(Cws.Columns(1))
'If there are unique values start the loop
If Rcount >= 2 Then
For Rnum = 2 To Rcount
'If the unique value is a mail addres create a mail
If Cws.Cells(Rnum, 1).Value Like "?*@?*.?*" Then
'Filter the FilterRange on the FieldNum column
FilterRange.AutoFilter Field:=FieldNum, _
Criteria1:=Cws.Cells(Rnum, 1).Value
'Copy the visible data in a new workbook
With Ash.AutoFilter.Range
On Error Resume Next
Set rng = .SpecialCells(xlCellTypeVisible)
On Error GoTo 0
End With
Set NewWB = Workbooks.Add(xlWBATWorksheet)
rng.Copy
With NewWB.Sheets(1)
.Cells(1).PasteSpecial Paste:=8
.Cells(1).PasteSpecial Paste:=xlPasteAllUsingSourceTheme
.Cells(1).PasteSpecial Paste:=xlPasteFormats
.Cells(1).Select
Application.CutCopyMode = False
End With
'Create a file name
TempFilePath = Environ$("temp") & "\"
TempFileName = "T-24 access Confirmation (GB Input or Teller Input)"
If Val(Application.Version) < 12 Then
'You use Excel 97-2003
FileExtStr = ".xls": FileFormatNum = -4143
Else
'You use Excel 2007-2016
FileExtStr = ".xlsx": FileFormatNum = 51
End If
'Save, Mail, Close and Delete the file
Set OutMail = OutApp.CreateItem(0)
With NewWB
.SaveAs TempFilePath & TempFileName _
& FileExtStr, FileFormat:=FileFormatNum
On Error Resume Next
With OutMail
.to = Cws.Cells(Rnum, 1).Value
.cc = "ziaur.rahman@primebank.com.bd;shahadat.hossain@primebank.com.bd;mh072501@primebank.com.bd;ma123002@primebank.com.bd;p.tanvir@primebank.com.bd"
.Subject = "T-24 access Confirmation (GB Input or Teller Input)"
.Attachments.Add NewWB.FullName
Dim sMsgBody As String
sMsgBody = "Dear Sir/Madam," & vbCr & vbCr
sMsgBody = sMsgBody & "We have received the attached list of users of your branch from IT Support & Services who are having T-24 access mode PR.GB.INP which includes both GB and Teller Input role." & vbCr
sMsgBody = sMsgBody & "The policy of the Bank prohibits the access of Teller & GB roles simultaneously in the system. As such, these dual roles of the mentioned officials are needed to be changed to either GB Input or to Teller Input (single role) in order to comply with the policy." & vbCr
sMsgBody = sMsgBody & "Against this backdrop, you are requested to ensure us which role they actually require for smooth operation of the Branch through a reply email with the attached list by the close of business April 4, 2016 to the following email address [EMAIL="ar032901@primebank.com.bd"]ar032901@primebank.com.bd[/EMAIL]" & vbCr
sMsgBody = sMsgBody & " Instructions:" & vbCr & vbCr
sMsgBody = sMsgBody & " 1. Open the attached excel file." & vbCr
sMsgBody = sMsgBody & " 2. Go to --Required Access-- Column." & vbCr
sMsgBody = sMsgBody & " 3. Click the cell to select required access from drop down menu." & vbCr
sMsgBody = sMsgBody & " 4. Save the excel file." & vbCr
sMsgBody = sMsgBody & " 5. Email the file to [EMAIL="ar032901@primebank.com.bd"]ar032901@primebank.com.bd[/EMAIL]" & vbCr & vbCr
sMsgBody = sMsgBody & "Thanking You." & vbCr & vbCr
sMsgBody = sMsgBody & "Best regards," & vbCr & vbCr
sMsgBody = sMsgBody & "Mohammad Shawkat Ali" & vbCr & vbCr
.body = sMsgBody
.display 'Or use Send
End With
On Error GoTo 0
.Close savechanges:=False
End With
Set OutMail = Nothing
Kill TempFilePath & TempFileName & FileExtStr
End If
'Close AutoFilter
Ash.AutoFilterMode = False
Next Rnum
End If
cleanup:
Set OutApp = Nothing
Application.DisplayAlerts = False
Cws.Delete
Application.DisplayAlerts = True
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub
i want the following text to be bold:
Code:
" 2. Go to --Required Access-- Column."
Just the "required access" part.
Last edited by a moderator: