emails

  1. B

    What chart/timeline to use to organise my messages

    Hello I have a lot of messages (300 approx) between myself and my bank that span a 1-2 year period. I want to enter all these messages into some sort of timeline, chart. That starts from the first message and progresses thru to the last message. I guess some sort of excel flowchart, or message...
  2. A

    VBA for sending emails with individual attachments

    Hello, I've written the following code for sending emails with individual attachments. The code cannot execute the attachment part. Without it, the code works fine. Could you please have a look and tell me how to modify the code in order for the attachments to work. Sub Send_Bulk_Email() Dim...
  3. S

    VBA – Auto Delete Emails After ‘X’ Days

    Hi all, Back Ground: Due to the nature of my business I receive a vast amount of emails, many of which I have archiving rules to store in designated folders. A good amount of the emails I would like to retain and some I would like to delete after x days. Here I will highlight that my IT Dept are...
  4. S

    Auto Delete Emails After x Days

    Hi all, Back Ground: Due to the nature of my business I receive a vast amount of emails, many of which I have archiving rules to store in designated folders. A good amount of the emails I would like to retain and some I would like to delete after x days. Here I will highlight that my IT Dept are...
  5. M

    VBA to Send Mass Emails with Individual Attachments

    Hi all, I need some VBA to allow me to send multiple emails (same standard email body but each with their own individual Excel attachment). I'm using Microsoft Outlook and Excel 365 Workbook Entitled: 'Raw Data' Sheet Entitled 'Sheet1' Column A: Email Address Column B: First Name (for email...
  6. D

    Exporting undelivered emails from Outlook to Excel

    As the title suggest, I'm trying to export Undelivered emails in Outlook to Excel (sheet1) I found this code on the web, and I'm having a little difficulty getting it to work Ideally I would like the data to appear in columns, a separate column for Email address etc The Emails are in sub-folder...
  7. S

    Send different emails to different email ID"s from Excel

    Hi everyone, I know how to send emails to several emails ID's at a time using VBA... But, I am looking to send different emails to each email ID/ID's at once. Like we do in a mail merge. Currently I am using mail merge whereas, some sections of the email are fixed and are taken from an word...
  8. S

    Column to row

    Hello fellows, I have a table of 2 columns “unique code” and “email” ,so the case is that one code could have many emails, so i want show all emails for specific code at one row.. Thank U
  9. R

    Need some guidance on how to approach this

    Hi Everyone, I need a little help with something. I have a report that I get twice a day, on emails that were sent to some of our generic inboxes. Each email has it's own row. Column C of this report contains a list of all the email addresses the email was sent to. There can be one or a...
  10. S

    Mail merge multiple data rows to one email address

    <tbody> Email Data Ste@google.com 1 ste@google.com 2 Bob@google.com A Bob@google.com B </tbody> Hi guys is there a way that I can mail merge 1 email with several rows of data, instead on several emails with 1 row of data? desired result - Ste recieves 1 email which states...
  11. L

    VBA Multiple body text references creating multiple emails - Help!

    Sheet contains an index of descriptions and order dates: Column D = Roof materials Column E = 12-09-2019 Below is to check order date in Column E and match to todays date. Checks to see if "Reminder Sent" is in Column F, if not, creates emails and places "Reminder Sent" with date/time in...
  12. A

    VBA Sending Outlook emails

    Hi Guys, I have a VBA that send automatic emails from excel, but I have a problem with formating and Hiperlink. In the Sheet "_Text" is the email with all the detalis that I need, Bold, Hiperlink... Can anyone help on this , please!! The file is on the link below! https://gofile.io/?c=WZ5iwB...
  13. S

    VBA EMail distribution not working

    Hello, I've built a program in excel VBA that creates emails and attaches invoices based on a distribution list. The program creates drafts of the email and saves them for review before we manually send them. The issue is that every single e-mail came back undeliverable. This is the e-mail I...
  14. K

    VBA to send email of sheet within the new email

    Hi folks, I didn't want to hijack another thread so I'll start a new one here. When looking at this thread (https://www.mrexcel.com/forum/excel-questions/1102928-modifying-code-send-e-mail-3.html) I like the way the code creates a formatted email grabbing a range from a worksheet. In my case...
  15. P

    How to read gmail inbox without outlook, dll ....

    I can send an email via vba without outlook, but I can not receive emails, can you help me ?
  16. R

    SumIF question, multiple criteria

    I am attempting to summarise a large data-set and am having trouble trying to collate the sum total. Hopefully the below example displays correctly on this page. Sample of data-set is below; <colgroup><col><col><col span="2"></colgroup><tbody> Qtrly Modified Date Docs Emails Q1-2018...
  17. S

    how to include rows of data from excel in a email automatically

    Hi All, I have the bellow table on a spreadsheet, courier is a drop down list where any of the below could be chosen, what i want to know is if its possible to make it so when ever i select a certain currier from that list can it send an email involving that row. e.g if i select Gopher on row 3...
  18. S

    Need Help Sending automatic emails depending on cell value

    Hello Ive, got a spreadsheet where column C is a list of drop down list of our curriers, and i want to know if its possible for it to send automatic emails when one of the cells is updated to a certain currier (in this case a currier called gopher) if so is it also possible for it to include the...
  19. Sharid

    Match Emails to URLs

    I have a list of emails, I need to link them to the correct URLs. Problem is there are too many to do manual. I was hoping for some vba code that would MATCH part of the string in the EMAIL to that of the URL and place it in the next column/s Example Sheet1 column A has all the urls <tbody>...
  20. P

    Vba to move emails from Inbox to personal folder

    Hi, I receive 20 to 25 emails a day from a common mail box daily to my Outlook 2016. I will then move those emails to a personal folder named "Daily email1" & "Daily email 2" based on email subject. I want this to be automated. Whenever I get those emails I want a button to run a code which...

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