"If you have already attended a training session, please let us know and we will remove you from our reminder list.Or, if you are unable to attend a live training session, the subcontractor training is available as a video demonstration on our Help Page.
You should have received a separate email with your username and password information in order to log in to Submittal Exchange." & _ If this information is not correct, please let us know. "You are receiving this invitation because you have been added to the Submittal Exchange system as a subcontractor or contractor working for a GC or CM. Dial in to the conference call number when prompted to do so" & _ Click ″OK″, ″Yes″, or ″Run″ if the web meeting software prompts you for permission&emsp 4. Enter the nine digit meeting number:" & _ "&emsp OR&emsp If you are already logged in to Submittal Exchange, open the website, click on ″Help″ in the upper right corner, then click on the blue ″Meet Now″ button which is underneath ″Join a Training″&emsp 2. Go to the Submittal Exchange public website (and click on the&emsp &emsp &emsp ″Join A Go-To-Meeting″ link in the lower right hand corner under ″Quick Links″" & _ "Instructions to join the web meeting:&emsp 1. "&emsp &emsp -&emsp You can join the web meeting from your computer in your office, no travel needed.&emsp &emsp -&emsp You also will need a telephone to dial in to the conference call.&emsp &emsp -&emsp The training will last no more than 30 minutes." & _ "OREVERY Thursday at 10:00 AM Central Standard Time (11 AM Eastern, 9 AM Mountain, 8 AM Arizona, 8 AM Pacific, 7 AM AKST)Thursday's Meeting ID: 966677330Thursday's Conference Call Number: 1-21How to participate:" & _ "EVERY Tuesday at 1:30PM Central Standard Time (2:30 PM Eastern, 12:30 PM Mountain, 11:30 PM Arizona, 11:30 AM Pacific, 10:30 AM AKST)Tuesday's Meeting ID: 168303738Tuesday's Conference Call Number: 1-63" & _ "You are invited to participate in an upcoming Submittal Exchange training session.Please note that our subcontractor trainings are ongoing, in that they are held twice a week, every week, and the information in this email invitation never changes, so please feel free to join us on any Tuesday or Thursday that is convenient for you!" & _ Attachments.Add "C:\subinvite\planswift.png" Subject = "Submittal Exchange Subcontractor Training Invitation" LCase(Cells(cell.Row, "C").Value) = "yes" Then Set OutApp = CreateObject("Outlook.Application")įor Each cell In Columns("A").Cells.SpecialCells(xlCellTypeConstants)
The current code I have will email all the users in the spreadsheet except I need it to send 20-25 emails than pause for a minute and send the next 20-25 than pause for a minute and so on. I have a excel sheet with 3 columns A = Email, B = Name, C = yes or no.
0 kommentar(er)
