vba outlook excel

Hi everyone, I'm an apprentice in Finance. My manager needs to automate the email process. What I'm asked to do: - Generate emails personalised to each receiver (DONE) - Attach the adequate file to each mail (DONE) - A table/screenshot of the most important financial KPI in the email body...

Hi. I have created a macro to which works as below First part one procedure refers a CSV file, create mails based on the row input & saves them in draft folder. this is important because I want to review mails before sending them / i may decide not to send / send later.... Second part other...

Hi, Se code below text. As I am running below mentioned script it is deleting every time approxm half the appointments So 1st time running example 100 appointments. second time running script 50 appointments deleted third time 15 etc etc So it looks as I am skipping one extra appointment for...

my goal with this code is to save my file to PDF and as XLSM file to my pc, then after that it gets put in an automated email where the PDF and XLSM file are attachments. My Problem: since I am just a beginner when it comes to VBA, I dont know what I am doing wrong.. Could you guys tell me...

This code is supposed to save the file as PDF to my pc and after that mail the XLSM and PDF file as attachments in an automated mail... but my pdf's dont get saved properly because my code is wrong and I just dont know how to fix it, does anyone know how I can fix it? Sub saveandsend() Dim...

At the moment my code works like this: when you click on play it automatically saves the file to PDF, then it opens the mail itself with a title, etc and also with a XLSM file. now I want it to add the same file as PDF instead of XLSM.. how do I do that if the title of the PDF is the cellname...

Hi All, I'm attempting to include my default signature into an Outlook email that is created from a macro I have in a workbook. So far, I have code that can create an email, add the necessary recipients, add the necessary attachment, and add the necessary body to my email. However, the .Body...

Hi, Trying to get a code so as when I am on a particular folder in Outlook I can copy and past all message bodies as per order of the emails in the folder. Can you help? Rgds, DEng

Hi Guys, I hope you are all well today :) I have been using the below to fire off emails to customers. So their Account number appears in Column A & their email in Column B and it then sends off information row by row (C3:I3) to each customer. What I was wondering if anyone knows how I may...

Hello guys, i need to attach excel file to outlook via VBA. example A2-subject line B2-mail id to c2-mail id cc D2-excel path which i want attach in my VBA code wrote as .attachment.add(range("D2").value but above code doesn't working. can any one tell me what would be code for attach excel...