outlook & vba

  1. O

    Automating Reports - Pasting Tables into Email

    Hi all, I'm running a basic macro to copy/paste/format emails to simplify reports that I'm handing off to my team. (This will be the 3rd question I've posted here this weekend and I'm immensely grateful for all of the support and patience you've all shown) As with most of my other questions...
  2. D

    Setting Appointments Through Excel with VBA/Color Coding

    I have a spreadsheet that I had developed that allows me to input a client's name and the meeting date I had with them. Once I add those two inputs to the spreadsheet and hit an update calendar button the Macro I had developed will generate a specified number of outlook calendar appointments...
  3. Z

    VBA Outlook export calendar items - Code 13 type mismatch error

    I created a code for exporting calendar appointments from outlook. It runs perfectly for me, however we get code 13 error on one of my collegue's computer who is supposed to use the macro. The error is at the "Next" line, and she uses the same outlook version as me. Can anyone please help me...
  4. O

    VBA Multiple attachments to email with 1 personalised

    Hello, I have a macro that I want to send 3 attachments to each person in the "RecipientList" however two of the attachments will go to everyone and one is a personalised attachment. It currently works but sends them as 3 separate emails and would like them to go once with the 3 different...
  5. N

    send each sheet to each persons via outlook

    I have a master sheet and a code to split it into separate sheet based on reviewer names, now i need to send all the splitted sheet to each of the reviewers based on sheet names, example: sheet named raj must be sent to raj@gmail.com, sheet named ravi must be sent to ravi@gmail.com I managed to...
  6. N

    email filtered range as attachment through outlook

    Hello All, I have a master sheet in which column C has names of employees, and i have data from Column A to Column AE, The number of rows change from day to day. I need a macro to send the rows to each employees as separate attachment via email, for example: if raj has 50 rows, it must get...
  7. S

    Calling new Subs

    Hello, So, with help of kind people here I was able to make most of my project work, but have hit the hopefully last bump. Basically, I have a worksheet that based on condition decides whether the issue should go after Quality, Logistics or Finances, and then generates an email to be just sent...
  8. K

    Copying mails from outlook to excel results in different date formats

    I'm trying to copy emails or just a single email at times from outlook and paste into excel but the date formats is different in each row which includes mails from below list. Have been asked to achieve this to calculate ageing of tickets assigned to team. How do I make today, yesterday and last...
  9. S

    Merged cell value to Outlook body

    Hi Team, I need to pass the value from B2: P11 range as seen in the below image to the outlook email body. Kindly help with the code.

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