mail macro

Good afternoon, For my work I have to send out multiple simmilar emails with a few minor changes per email towards cliënts. I am making (or trying) to make tool that prepares the emails for me as a whole (receiver, header, body). I would only have to click a hyperlink, check if everything is...

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

Hi, Im trying to Email 16 different email addresses a copy of a specific sheet from my workbook. I've almost suceeded in that sense that i've managed to create 16 emails and attach 16 different sheets. However it wont Add my address list to the "To" field in outlook.... I've now been staring...

Hi There, I'm new to this forum so please redirect if i'd post in the wrong area. :) With that said im currently stuck on figuring out how I could arrange an automated email process via Excel and Outlook. I've come so far that I managed to create an email list and generate a given Subject +...

Hi Guys, I am using the below as part of a macro to email some pivot data to a list of customers. but at the moment it only goes to one email address. I tried amending it to look in a specific range for the hyperlink and it errors. can anyone help? many thanks Jamie Receiver = Sheets...

Dear all, I have a excel file with some deadlines and tasks. What i'm looking for is a vba code or formula to alert me which task is available for the day, when i arrive to the office. Also, I'm trying to, in some tasks, send a email with the fields "To", "Cc", "Subject" and "Text/message body"...

hello i have developed code but it shows a run time error can some one please advise whats is the issue Private Sub CommandButton1_Click() Range("A2").Select While Not ActiveCell = "" Mail_To = ActiveCell.Offset(0, 0) Mail_Subject = "testing" Mail_Voting = ActiveCell.Offset(0, 4) Set myolapp =...

Hi there, I'm new using macros, so there are a lot of things that I still don't understand but I require the solution for this issue. The thing is: I need to open a specific .msg outlook file when running the excel macro using a simple Ctrl+Key. I'm trying to follow the solution specified here...

Hello, I have a spreadsheet in Excel with First & Last Name combined in one column and three other columns.The columns are as follows; <tbody> First&Last Name Username Password Email address ChristineMurray CMurray_HP Test!23 Cmurray@tbh.com ChristineMurray CMurray_GH Pts.345...

Does anyone know how to build a macro that can separate a letter mail merge into individual pdfs? The letters will be one page long. Also would it be possible to name each pdf as the address line on my document? If this helps the address line is a field on my mail merge. Thanks a lot!

I've created a macro in a module in a macro-enabled workbook to send mails to project members based on the macro I found here: Spreadsheet Page Excel Tips: Sending Personalized Email From Excel There are 3 PC's, all running Office 2010 Professional Plus on Windows 7 with the exact same settings...