9/6/2023 0 Comments Microsoft edge reviews 2021![]() ![]() An added bonus would be for the code to populate fields in the Excel table that show which template was sent and the date. oft template to open and populate as we have different ones we will send at different times. Ideally, I would like to be able to Select which. ![]() Subject = "ACTION REQUIRED: 2021 PROCESS ATTESTATION REVIEW-" & "iGrafx ID-" & sheet1.Range("E" & CustRow).ValueĪpplication.Goto Reference:=Sheets("Sheet1").Range("A1"), Scroll:=True Next CustRow Set otlApp = CreateObject("Outlook.Application") Subject = Replace(.Subject, strFind, StrNew) HTMLBody = Replace(.HTMLBody, strFind, StrNew) Range("E9999").End(xlUp).Row 'Determine Last Row in Tableįor CustCol = 5 To 13 'Move Through 9 Columns ![]() Set otlnewmail = otlApp.CreateItemFromTemplate("C:\Users\u719361\Downloads\Metadata Change (35).oft") With sheet1 Set otlApp = CreateObject("outlook.application") _UPDATED CODE:_ĭim CustRow, CustCol, LastRow, TemplRow, DaysSince, FrDays, ToDays As Longĭim DocLoc, TagName, TagValue, TemplName, FileName As String ![]() oft file, it populates the email address and the value in the subject line but am unable to get it to populate the fields in the table in the body of the email with the data from Excel. oft template and then populates the data fields in the corresponding location in the table as well as enter the Email information in the To: line (so it will look up in GAL) and populate the iGrafx ID at the end of the Subject Line. I need to click a button in Excel that opens the. I have an Outlook template saved with basic text and a table in the body. Some data fields may contain >255 characters. IGrafx ID, Process Owner, Email, Process Title, Process Summary. I have a table in Excel with the following data fields: I am new to VBA and need to have this working by Friday. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |