Search results

  1. A

    Updating records using Top 55% or Random function VBA

    I'm getting Type mismatch error at below line. The value of i could be from 1 to 4 (this shows how many times the activity will take place quarterly for a staff member) Dt = CDate(fncRandom(i))
  2. A

    Updating records using Top 55% or Random function VBA

    Arnelgp, there is End if statement missing . I'm getting an error message . Where do i need to put it?
  3. A

    Updating records using Top 55% or Random function VBA

    Guys instead of using TOP 55 PERCENT , Can we use random function to update records ? Basically we need validation to check if its first quarter and if Flag=true then update randomely 'MonhRef' field to Jan/Feb/Mar. For second quarter the MonRef field will be updated to Apr/May/Jun and so on...
  4. A

    Updating records using Top 55% or Random function VBA

    Guys, Please see attached the spreadsheet with some data, I want to update the records so that MonthRef field is assigned with random month of the quarter. My code below updates the records using top 55 percent but it's not right (Looking at the Staff member field values) as same staff member...
  5. A

    Create a form in outlook to pre-populate values

    Hi Guys I am new to outlook vba and would like to create a form that will open up when user click on a button on the ribbon. It should pre-populate the following things: 1. The email subject on the form label. 2. 10 digit account number in a textbox on the form. (The account number is the part...
  6. A

    Updating records using Top 55% or Random function VBA

    Hi Guys My challenge is to quarterly allocate various activities (e.g Call audits, Staff reviews,meetings etc..) for the staff members. Sometimes there are 2 or 3 activities to be taken place quarterly for the some of the staff members. So I have done the following and need your help in...
  7. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Guys, The only thing left is saving down all the files automatically without opening the dialog window. I hope anyone out there can help me with this. Below is the code we got so far: Sub SaveAttachments() Dim objOL As Object, objSelection As Outlook.Selection ' Instantiate an Outlook...
  8. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    I changed the code to below but its still asking me to click save in dialog window: Set xWdApp = New Word.Application xExcel.DisplayAlerts = False xPDFSavePath = xExcel.Application.GetSaveAsFilename(InitialFileName:="U:\ABC\Outlook\Word\" & Environ("username") & " " & Date...
  9. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Even that time it was showing dialog box to choose folder where pdf file needs to be saved. I changed the line of code as below so that it points to the right folder but I want the files to be saved down automatically and as i said earlier the files names should be picked up automatically (the...
  10. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Also the code is not considering "pdf" files which needs to be saved down as well.
  11. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    AUtomatically each PDF file should be saved down in folder : U:\ABC\Outlook
  12. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Thanks Gasman , It worked but everytime it creates PDF file , a dialog window opens up and ask for a name . Can we automate it so that it saves PDF file with the name as below 'The person who sent an email' & 'Date when the email was sent'
  13. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Can you please help me to combine 'Loop through each email' code with the code I sent? Many Thanks
  14. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Hi Guys Can anyone please help me with this? My above code works fine if I select one email in a folder but doesn't work for multiple emails selection. How can I save email body and attachments in a separate pdf file for each email? Thanks
  15. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    June, The following code will combine email body and attachment in any format into one pdf file. It works really good. But I am not able to select multiple emails , this code works only if we select one email. Public Sub MergeMailAndAttachsToPDF() 'Update by Extendoffice 2018/3/5 Dim xSelMails...
  16. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    ok, thanks June.
  17. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    I tried to run code but it didn't convert word document to pdf. It just saved down word document in a folder. I want to save it down in pdf format in a folder. Thanks for your help so far.
  18. A

    Storing monthly and quarterly activities for each staff member in a table

    Just got to know from a colleague who used the following function to quarterly allocate activities. case 3 means 3rd month of every quarter . Public Sub AllocateNonRegular_QTR() Dim rs As Recordset Dim rsa As Recordset 'Dim strDate As Date 'Dim strQStart As Date 'Dim strMonth As Integer...
  19. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Thanks June. Which email folder will it look for ? I am thinking of something like selecting the emails in an email folder and then run macro so it will look for just attachments in those emails only and not the all the emails . How can this be done?
  20. A

    Outlook VBA code to convert attachments to pdf and save in a folder

    Hi Guys I am looking for outlook VBA code so that when the user selects the emails in his folder and run the macro then it should check all the attachments in the email. The below things macro should do: 1. If its word document then convert that to PDF and save it down in a shared folder. 2...
Back
Top Bottom