Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 9
Default Need Macro help to stop repeating some info

I am trying to tweak a macro by adding new rows into the tabs and then add them to the macros for compilation in an email. The issue I have is that the project level information is repeating into the package information in the email and I only know enough to be dangerous with macros. The "Test Strategy" information is on the project AND the package level and it should only be giving me the specific package information in the email.

I tried to attach the doc, but it's too large.

Let me try to phrase it another way; The macro should be giving me unique information in each section in an email, but it's repeating the information with each subsequent section. The macro copies all info into a separate tab and then compiles it into an email. The separate tab is working, but not the email.

Let me know how much of the macro you want to see and I can copy it here. I tried to just delete tabs and it broke the macro.
  #2   Report Post  
Junior Member
 
Posts: 9
Default

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.

'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXX
'X Package issue text added to the email body
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXX
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
  #3   Report Post  
Junior Member
 
Posts: 9
Default

I have the full spreadsheet posted at the link below.

http://www.vbaexpress.com/forum/show...038#post346038
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeating Info Change Junderwood57 Excel Discussion (Misc queries) 1 September 25th 08 04:55 PM
How to stop background from repeating Steve Excel Discussion (Misc queries) 2 September 10th 06 11:53 PM
can i stop repeating values? Haitham Excel Discussion (Misc queries) 2 August 3rd 06 09:01 AM
How do I stop data from repeating? Donald D Excel Discussion (Misc queries) 2 September 26th 05 07:33 PM
Header - stop repeating on every page! sararose27 Excel Discussion (Misc queries) 2 February 17th 05 11:41 PM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"