emails

  1. A

    Guys I need help with a VBA code at my work

    Guys I want to create a code , This code will query a subject for example "facebook" and will count how much emails received with this subject from inbox and will put these emails in specific worksheet that i create with the name "facebook" for example
  2. A

    VBA export emails with different worksheets per inbox category

    Hi guys I need help to write a code to take emails per category from inbox with counting .. For example i have categories called "ARBOR", "NAGIOS" and i want to put emails received from this inbox folder with subject and count and date
  3. M

    Open email limit

    Hi Guys I have created a macro, which create emails and attach files. There are about 115 email that i create. I havent activated the code to send those email automatically as i want to check them before i send them. But for some reason , it only opens up about 90 emails out of 115. Does...
  4. T

    Refresh, split data and email data using VBA

    Hello all, I'm new to this site and it was recommended by afriend - thankyou for letting me join. I'm not familiar VBA but aware of the powerful thingsit can achieve so look forward to developing my knowledge. I was hoping there was a code available which I could use in a Macro. I have an...
  5. P

    Can't Review email using SMTP server with CDO library

    Does CDO messaging not support reviewing emails? My client (a state hospital) must encrypt patient-related emails with Virtru. This is a setting on the message so I need to set the message to Review. Unfortunately that is not a CDO.message option! Can this be done? If not what other library can...
  6. S

    Pivot Chart, filtered by top 10 and exclude column

    I have a pivot table that includes Sum of Sent Emails, Sum of Received Emails and the Total Emails (Sent + Received). I filtered the data to show the top 10 users by Total Emails. My problem: I want a stacked bar chart of the top 10 Total Email users and a pivot chart will not allow me to...
  7. K

    Search and return messy spreadsheet for emails

    Hi! I have a large (6000+ rows) spreadsheet which is a mess. Its just copy/paste of dozens of different spreadsheets, containing customer information from several different stores. Goal My objective is to retrieve all the customer emails from the spreadsheet so we can import it to our...
  8. A

    Macro to create hyperlink and open a email message

    Dear All, I have a spreadsheet where I have the details of emails received for a day. I save the emails in local drive by creating folder for month and subfolder for days. Ex: May2018 05012018 05022018 05032018 and so on... I store the emails based on the dates and copy the email name to the...
  9. gebo84

    VlookUp to sum up more than one column or value

    I have a "tasks data" spreadsheet where i am capturing staff daily activities. For example in column A is Monday, B is Tuesday and so on, with times down the rows in 15 min intervals, the staff member would then fill this out as the day progresses on tasks they have performed. I am trying to...
  10. L

    Adding bold into a email macro

    Hi, I have been toying with an email macro that bulk emails clients with taylor made near identical emails in the click of a button. I am almost done however I have encountered a minor issue whilst trying to add a bit of flair to the signature. Does anybody know how I would correct this code...
  11. B

    Match and Assign

    Hi, I have an excel sheet with two columns Col 1 - Named Bounced - contains - All bounced emails Col 2 - Named Data - Contains Complete Email data Requirement - I would like to assign "Y" in Col C if the email in Data matches with Email in Bounced. This is to separate the bounced emails from...
  12. C

    Macro to assign categories to emails in outlook

    Hi, i am a vba total noob and am looking for a way to assign a category to a set number of emails in outlook as a way of allocating work. The categories are all set up for each person, and i will have an excel file that has the categories and how many emails to assign for each person. The...
  13. 1

    Charts not showing correctly

    I have 2 chats on the same tab. Both are the same. 1 shows emails received by date, 1 shows emails sent by date. Both have the same filters, and the same fields used. They both pull from formula fields in different tables, and the formula is the same. The received table does not show dates...
  14. T

    Attachments

    Is it possible to add attachments to the forum or emails?
  15. V

    vba count emails per day including sub folders

    Hi, I have the code below that outputs the email count per day for a generic team inbox, in this example the inbox is named genericqueries. I am looking for a way to also count the emails in sub folders within this inbox. Also, this email address contains roughly 8000 emails and it takes an...
  16. A

    sending emails from drafts folder in outlook

    folks, i have a macro that creates a bunch of emails and stores them ready to send in a shared email account. once reviewed by my manager, they are to be sent out. I have been trying to find a macro that will enable these emails to be sent all at once from the shared account drafts folder. Can...
  17. C

    Display Email in Outlook via Excel

    Hello, I have code in Excel 2016 that creates and displays multiple emails when the code runs. However, these emails are displayed 1 by 1, as they are created. How can I create all of the emails w/o displaying them until the end of the code, then display them all at once? 'EXAMPLE For x = 1...
  18. S

    VBA Help - Filter each value from the data and paste in outlook

    Hi Team, I am looking for a code to filter each value from the data and paste the visible data in outlook in different emails at each filter value with a subject of filter value. pls help
  19. D

    VBA Command from Excel to forward emails in Inbox(outlook)

    Assume below is a excel worksheet with consolidated emails from MS outlook(by export data function as .CSV) , I need help to develop VBA code to trigger action to forward email from ms outlook Inbox folder where below Subject = C2, then should get forward to assign=D2,similarly C3 then should...
  20. K

    CDO email Signature

    My company has a particular signature that we use and i was wondering if there is a way to add it to the code i have to send CDO emails? here it is with the colors can i add this to the end of my email somehow? (its edited to keep it anonymous) Mit freundlichen Grüßen / Best regards company...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top