IBC section 2902.3.2 states the path to travel to facilities shall not exceed a distance of 500 ft, but then in the next paragraph there is an Exception stating the maximum distance can be exceeded if approved.
The building in question has expanded multiple times and now the path to travel to...
Agent666,
That suggesting worked perfectly thanks for pointing that out.
JG2828,
Thanks for the info on file names and creating a valid attachment link.
I am trying to create a template that once a few cells are filled in the user can run a macro and auto populate specific named sheets to enter specific info.
To use this spreadsheet the user is required to enter specifics (Series/Chute#) in Cells A2&B2,A3&B3.... within the summary sheet then...
vcolella,
This works well thank you. Do you know if your able to also include a drop down list within the Input box versus typing? Within Cell C1 in the Loads worksheet I have a drop down list of all active worksheets and would like to try to take the input box one step further?
I would like to modify the following code so I don’t need to step into and edit the sheet names every time I use it. Currently I step into the vba and change the sheet name to one of the 10 sheet names within the workbook(W-shape in 3 places as shown highlighted below for this example). Is there...
Agent666,
Thanks for trying on your machine at least I know the code works. I did check my settings and they were the same so removed 365 and reinstalled with no luck.
I have used this coding bellow in the past but now I am getting a Compile error. looking for some guidance how to change this coding to get around the compile error.
Sub Sendoffice365invoice()
Dim myItem As Outlook.MailItem
Dim myolApp As Outlook.Application
Dim myRecipient As Recipient...
To resist uplift to a footing that sits directly on solid granite my customer plans on drilling a 5.5" diameter hole, 10 feet deep with 2 #8 rebars embedded into the hole with 4000 psi concrete.I came accross equation 10.8.3.5.4b-1 on page 10-137 of 2012 AASHTO book to calculate to calculate the...
@IRstuff,
I am not sure what you mean at missing MJ's point and which one sticks. All three emails are placed in the meeting invite once I run this macro the way it is written. How would you write the code below to be more correct?
Set myRequiredAttendee =...
@MintJulep,
That would certainly clean things up, but when I change the code (below) I receive a compile error when I try to run it.
Sub Sendofficeweeklymeeting()
Dim myItem As Object
Set myItem = Application.CreateItem(olAppointmentItem)
With myItem
.MeetingStatus = olMeeting
.Subject =...
@MintJulep,
If you look at the lines before 86chevys10 I have 2 other email recipients.
Sub Sendofficeweeklymeeting()
Dim myItem As Object
Dim myRequiredAttendee As Outlook.Recipient
Set myItem = Application.CreateItem(olAppointmentItem)
myItem.MeetingStatus = olMeeting
myItem.Subject =...
Below is the code I found to work :)
Sub Sendofficeweeklymeeting()
Dim myItem As Object
Dim myRequiredAttendee As Outlook.Recipient
Set myItem = Application.CreateItem(olAppointmentItem)
myItem.MeetingStatus = olMeeting
myItem.Subject = "Weekly Meeting"
myItem.Location = "Front...
@IRstuff,
I am assuming that this is not something that VBA can do and if that is the case than I will continue with the built in features. I couldn't figure it out so thought I would throw it out there and ask before I just gave up on it! It would be cool if outlook could have a macro recorder...
@SkipVought,
What I would like to get out of this thread is help writing this specific macro which creates a scheduled meeting email invite. Once I run the macro the only thing I would have to do is send the meeting request. Every thing you & others have mentioned I am utilizing now with the...
@davidbeach,
That is what I currently have setup, but it isn't working exactly how I would want. If I can fix this VBA language above I will get exact results/capabilities I am looking for.
MintJulep,
Thank you for your ideas/comments! I do realize the difference between an appointment and meeting I just wasn't sure if you meant the code language made much of a difference between meeting and appointment. What I am truly looking for is the correct code language to create a macro...
MintJulep,
I am trying to set up a new meeting not appointment if that makes a difference??
1. Instede of using [highlight #FCE94F]Set myItem = myolApp.CreateItem(olMailItem)[/highlight] what language would set up a meeting?
2. [highlight #FCE94F].When = "Tuesdays 9:00- 9:30 "[/highlight] I...
