Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109086

Re: Need Macro help to stop repeating some info

Show all headers | View raw

I think this is the section where I need to add something to separate
Pkg 1 from Pkg 2 and Pkg x (template page) in the email compilation.

'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
'X  Package issue text added to the email body
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
strBody = strBody & _
"<font face=""Times New Roman"" size=""5""
color=""Black""><B><br>" & strPackageSheetName & _
" Install: " & strPackageInstall &
"</br></B></font><p></p>" & _
"<font face=""Times New Roman"" size=""2""
color=""Blue"">" & strPackage & "</font><p></p>"


End If
strBRD = ""
strFSD = ""
strReq_Traceability = ""
strTest_Plan = ""
strTest_Results = ""
strImplementation_Readiness = ""
strTOGPM = ""
strTestStrategyPkg = ""
strCP = ""
strITSPkg = ""
strPackage = ""



Next ws

Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub




-- 
ksquirt

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Need Macro help to stop repeating some info ksquirt <ksquirt.11cd69e8@excelbanter.com> - 2016-07-14 16:10 +0100
  Re: Need Macro help to stop repeating some info ksquirt <ksquirt.11cd9418@excelbanter.com> - 2016-07-14 19:35 +0100
  Re: Need Macro help to stop repeating some info ksquirt <ksquirt.11cda228@excelbanter.com> - 2016-07-14 20:48 +0100

csiph-web