bulk

  1. Dazzawm

    Send Emails In Bulk From Spreadsheet

    I have a spreadsheet as below. Is there a macro that will open my email client and send an individual email in bulk to all in the sheet? Thanks <colgroup><col><col span="2"><col></colgroup><tbody> Body 1 Body 2 Title Email JMatear sdgdfbxfb Login Details example@gmail.com JBrowning fsfbdfb...
  2. C

    Using excel VBA delete multiple lines in a active sheet

    Here is an example of what I have and what I would like to accomplish. <tbody> OPEN WORK REPORT Period NUMBER WORK ORDER DESCRIPTION TYPE 25524484 ACCIDENT accident rollover Period NUMBER WORK ORDER WORK ORDER DESCRIPTION TYPE 25858720 BULK ISSUE Bulk...
  3. P

    Formula to check if data is a bulk delivery

    Hi all, hoping you can help as I'm a bit lost with this. My data has several columns of information regarding deliveries, the dates they were made and if all the items ordered by the customer were in the delivery. I need a formula to check the data and put a value of "bulk" if a delivery with...
  4. P

    Help looping a form

    I work for a company that packages numerous products with different brand names. Sometimes we package the same product under a different brand name but the Lot number, expiration date, and product code are still the same. Because of us packaging product this way, this is considered a split lot...
  5. P

    Run-time error '1004': Unable to set the NumberFormat property of the Range class

    I am currently using a password protected spreadsheet that someone else created at my work. The problem that I am having is that I can't format a cell with the number format option on the Home tab. It is greyed out. I have a userform that the user will enter in a product code in text box. When...
  6. 2

    Organising Data

    I have below columns and want to organise image urls from column B in columns D,E,F,G etc as per their position. How can I do this in bulk. Please help
  7. D

    Consolidate Multiple columns into one Columns

    Hello All, So I create product upload CSV and each product has a different choice such as a Size, Unit, Color, Size and Units, options etc. These choices are all on different columns however I need to consolidate all into one column at the end. The reason because I need to upload the choices...
  8. J

    Macro not able to connect to MS Access DB

    Hello All, I'm new to this forum so I hope I am posting this in the right local. I'm at my wits' end with a macro designed to pull from Access. I'm receiving Run-Time Error '1004': Application defined or object-defined error The debugger selects ".Refresh BackgroundQuery:=False" at the...
  9. C

    VLOOKUP which gives highest value

    Hi, The spreadsheet I am using has 3 orders which make one bulk order. The 3 orders have 3 different finish dates. Is there a way of putting on a vlookup formula which then chooses the highest date (this is to create a pivot table). For example: Order Finish date Bulk order 1...
  10. M

    pulling text from a string

    How can I pull certain text from a string using an fx? In my target column I only have two different sentences. OSV to Bulk Anodize OSV to Rack Anodize depending on which one it is, I only want to extract either the Bulk or the Rack text. How can I do that?
  11. B

    Excel VBA to create multiple distribution lists in outlook (2016)

    Hello, I'm looking for a way to create 80+ distribution lists in outlook and include contacts in those groups. My data looks like the below. I would need to create a new distribution list(contact group) in outlook based off of the name in the DistList column and add new contacts to it. For...
  12. B

    Excel VBA to create multiple distribution lists in outlook (2016)

    Hello, I'm looking for a way to create 80+ distribution lists in outlook and include contacts in those groups. My data looks like the below. I would need to create a new distribution list(contact group) in outlook based off of the name in the DistList column and add new contacts to it. For...
  13. J

    Bulk Encrypt password to Multiple Spreadsheets

    Hi, My first post in this forum, so please be gentle. I have a client that has a workbook of c700 spreadsheets for which I have found a code to seperate the workbook each month into individual spreadsheets and then save in a folder and distribute accordingly. I am now looking to encrypt a...
  14. M

    Auto Fill Column with VBA Code if condition is Matched

    Hi I have Multiple Entries of Same Bulk Code in Excel Sheet I'm looking for VBA Code with the following Condition If one entry of bulk code contains Intermediate against it in Material Type, for all entries where that bulk code appears, display bulk received as YES(See Screenshot)...
  15. M

    Fx needed

    <tbody> "OSV TO BULK ANODIZE RED" </tbody><colgroup><col></colgroup> What fx can I use to get rid of the "OSV TO " and only show the rest.
  16. J

    Trying to Combine Two Queries Which Have Common Columns

    Hey everyone, I hope you are able to help! I am using Excel 2016 + Windows 10. I am trying to merge two web queries which have three common columns (Date, Campaign Name and Ad Group Name) please see below for the tables and desired outcome. I tried doing a full inner but I end duplicating the...
  17. Z

    how to organize data in respevtive pivot tabe report filter, column labels, row labels and values

    hi everybody! i am having some trouble in using pivot table after a few years break so so if anybody might guide me what am i forgetting i am working in garment cutting and for every new order i have to maintain a record of the measurements 1: cad pattern 2: first garment 3: first garment...
  18. U

    VBA: Bulk Inserting Hyperlinks to Sheets with Same Name as Cell Value (Excel 2016 VBA)

    Hi! I’m hoping for a macro that can: Start in A36 of the active worksheet and continue downward, stopping when it reaches a blank cell (ideally, it could do this at once for all selected worksheets, if multiple are selected.) In each of those applicable cells, insert a hyperlink to the...
  19. T

    Multiple Excel files containing invoice data ...how to convert to one Excel?

    I have a ton of invoices I've extracted from a couple of email addresses that I then turned into Excel documents with the Able2Extract PDF to Excel convert. The problem however, is the data looks like this: Untitled-1.jpg And I'm wanting it to have one big excel sheet with multiple columns...
  20. P

    How to send multiple email address through a slicer in excel vba

    Hello. I need your help. This is how the single email is sent: On the tab "Email", there is a slicer and a series on pivot table. You select the name in the slicer and the information will change in the pivot table. After this change happens, you press a button and it will email the...

Some videos you may like

This Week's Hot Topics

Top