1. M

    VBA outlook choose email

    Is there a way to prompt the user to choose an email just like pickfolder?
  2. L

    Email range without selecting sheet or range

    I am trying to automatically send emails from a spreadsheet at certain times, but I want to avoid selecting sheet that has content I want to send. Here I have what works if sheet "Rap_Zmiana_Trans" is active when macro runs. I want to achieve the same without selecting sheet. ***I know I can...
  3. P

    Unsure why this automatic Calendar reminder is not working.

    Sub COOutlookReminder() Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim myRequiredAttendee As Variant Dim Address As Variant Set OutApp = CreateObject("Outlook.Application") Set OutMail =...
  4. E

    Create mails with table - standard header specific row

    I am trying to create a code that can create Namelist amount of emails. Each email should include some specific cell variables such as name and email AND a table in which i need the header from the excel sheet and a specific row. I have tried to incoporate a take one row at a time approach but...
  5. B

    Excel Macro Mail

    Hi everyone, I am totally new with Excel VBA and i need to make a macro which : open a mail -> take attachment -> unzip this attachment -> open this attachement In othe other side with the title of the mail, search the file in my computer for exemple if the title of the mail is "CTA_2022" i...
  6. Jyggalag

    Send out email through VBA and Macro in Outlook

    Dear all, (Please note that I am using the Outlook program in Windows). I currently have a setup that looks approximately like this (please ignore the snippet on the right side, it is purely to show what an email looks like in an outlook format): I was wondering if it would be possible to...
  7. T

    Loop VBA with multiple cell references

    Hi, I want to create a makro that loops until there's no more entries in my excelsheet where I get the data from. I.e. It should stop looping when there is a blank cell. As a real beginner in VBA I'm not sure how I can insert som code into my existing code for that to work. I bet there's a real...
  8. D

    Send/display email through Excel in Outlook

    Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...
  9. D

    Convert Excel to PDF before sending out automatically by email

    Hello Everybody, I am currently trying to create an Excel macro that converts my excel sheet into a PDF file and then sends it out by email. My current macro can do this, but it cannot convert it to a PDF file. I tried to merge my current VBA formula with the one here: to convert my excel...
  10. C

    Email Hyperlink

    Hello: When I click an email hyperlink, it currently opens to the Mail app. Is there any way to have this switched to Outlook? Thanks OJ
  11. F

    Sending mail

    I was using a CDO sub to send mail and it work great. I now have upgraded my computer and bought the newest subscription for Excel. I am not sure what happened but the sub does not work any more. I am hoping someone will be able to give me some code that will work. This has ruined my entire...
  12. R

    VBA Code to mail from excel is attaching all files in range

    Hello Everyone, This is my first post so thank you very much in advance for any help.. I am trying to send individual mail from excel to three team members. I have member name range in C column, email id range in D column and file location path range in F column. My problem is when code is...
  13. H

    opening all .msg files from a folder and saving them as pdf

    Hi, i have saved almost 500 mail copies in a folder. the task is to open all the mail copies and save them as pdf. the below code loops through the folder. however, i need help so that i can save each mail item as pdf. help would be highly appreciated Sub bla_OK() Dim objOL As Object Dim Msg...
  14. R

    Excel code to trigger mail

    I've a monthly data base register with 50 plus members. I find few members are not entering data in specific cells or entering data which is out of date (EX: Actual end date is exceeding present date). I need to send mail every time to all defaulters. Please find my requirement below and anyone...
  15. H

    Call Word document (with mergefields ready) and MailMerge it from Excel (all hosted on Sharepoint)

    I have to setup a series of mail merged forms for my school to invite guest speakers to our classrooms. For that, I have setup a table called Guest_Speaker_MM. I've already created all the merge fields and tested them using manual mail merge and they worked fine. However, when these files...
  16. C

    Macro code

    hi I am trying to copy entire row based on cell value and also wants to create a mail with the copied row data. want to paste the copied row as mail body. can anyone help me with this
  17. K

    Mail Merge - Blank Spaces

    Hello, I am working in a mail merge document, and I need the output to look something like this: Vacation: Life Insurance: Disability: etc. However, the issue is that sometimes the fields are blank, and if they're blank it messes up the spacing. I want the document to ignore any blanks...
  18. L

    mail merge change the format of the date

    Hi I am not sure if this excel or word issue. I have a column in excel which has dates formatted as below. When I mail merge to word, I loss the format and the date will convert to something like that 30/09/20, instead of the format below. Why is that. Thank you so much...
  19. S

    How to get outlook mail data into excel macro

    Hi Guys, Hope you all going good!!! I need your help to get outlook email data into excel sheet. Following details to be collect:- 1.From email address. 2. Mail Subject. 3. Mail body. 4. Also macro have to fetch data for customised dates. Thanks in advance.
  20. V

    Mail Merge Code

    Hi, Thanks in advance My Query is My hosting account has a limit of sending only 200 emails/hour - 20 per minute. I broke my list down into sets of 200 to send out every hour. However, when using mail merge I can't find a way to control how many of these are sent per minute. Is there any way...

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
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 "".
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