1. 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...
  2. 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...
  3. 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 /...
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. 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...
  14. 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.
  15. 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...
  16. C

    Mail to be sent from Excel with info from specified columns

    Hi Team I would like to send a mail from excel with the info from - specified columns - Specific email body Please see screenshot - SDA email - that should be To - TL Email - That should be in CC - Reason and INC/WO should be in subject with line "Returned Ticket...... - Email body - "Your...
  17. P

    Mail Merge Function with emailing different excel worksheet under email attachment

    Hi All, When doing Mail Merge, is it possible to send individual customer with individual different excel worksheet in each email as an attachment? Cheers, Peter
  18. M

    Macro to use mail merge with word and then save each printout as a pdf

    Can someone help with the coding to save a letter template in Word that will fill with each persons name (column a) via mail merge and then save each page as a unique file name under (column B)?
  19. S

    2 Worksheets and Yes answer

    So I have 2 worksheets. Sheet 1 contains 425 rows and the last column being used is O currently. The first column contains a unique identifier number. Sheet 2 is used to send out mail merges it contains less rows until it is filled and the last column being used is S currently. Now in Sheet1...
  20. Expiry

    Mail Merge/ VBA

    I have a table, listing about 500 people that have been issued between 1 and 12 roles each. Each row of the table has a role. So, if Mr Smith has 12 roles, he will appear on 12 rows. I want to do a mail merge which would send one email to each person that lists their roles. I can't work out how...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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