e-mail

Using VBA in Excel, it is possible to control Outlook but to what extent? The problem I have is as follows: Suppose Person A e-mails Person B. The e-mail contains 1 Excel workbook, along with a pdf and a Word document. When Person B receives the e-mail, they can: Accept (in which case...

Ok guys, this might take some time, so please bear with me. Is it possible to create a macro that would run everyday (either automatically or when prompted by me) and resend a reminder e-mail? I would have the outlook message saved in a folder and have a cell on the excel table with the path...

Hi Guys, I am struggling to figure this one out. I have an excel workbook which I am running a Macro which takes the active page and attaches this to an e-mail. This is fine and works as it should however I then need to attach the same sheet as a PDF to the same e-mail. Is this even possible...

Hi, so Row A contains lots of different but unique individual e-mail addresses, thousands in fact in the format : Alan.Smith@MrExcel.com Karen.Jones@MrExcel.com Clive.Bloggs@Microsoft.com Brenda.Forbes@MrExcel.com what I need to do is count the instances that an e-mail Domain Name appears so...

I have a data that is in raw form i want to extract 3 rows and convert them to the columns. Row are E-mail, company name which is always below member id and rep. I have also bold the rows which need to be converted to columns. I have about 10000 rows of data <tbody> <tbody> 1. MEMBER ID...

I have VBA code to create a pdf print file from my current worksheet and create an e-mail with the attachment. What code do I need to add another file that is already saved in one of my directories? Thanks in advance for your help.

I would like to make a macro to E-mail of Sheet5 or Sheet5 (A:1,J:300) to Sheet5 H5 (an e-mail address) in vba. Can you guide me in the right direction? I can make the macro I just don't know how to wright the code.

I would like to make a macro to E-mail of Sheet5 or Sheet5 (A:1,J:300) to Sheet5 H5 (an e-mail address) in vba. Can you guide me in the right direction? I can make the macro I just don't know how to wright the code.

Hi I have a problem with a routine that:- 1) loops through a customer table (CustCode(col1),FirstName(col3),EMail(col5) 2) make a copy (based on CustCode) of a master workbook and sends it to a designated directory 3) uses outlook to send the new workbook to the sender (using firstName, Emial)...

Hi! I have been browsing the forum and found a very good code for sending an excel sheet as PDF on e-mail by a user ZDI (?). I modified it a bit - picking cell-references into the body text of the e-mail, subject and To/Cc fields. The code looks like this now: Sub AttachActiveSheetPDF() Dim...

I have a worksheet that has data and images on it. I want to e-mail everything that is visible in a given range, including the images. I can already select all the data and put it in the e-mail using Set rng = Sheets("Invoice").Range("A1:I151").SpecialCells(xlCellTypeVisible) but I need the...

Hello, I have a task to send mail to the person responsible based on the dept code with the part number. Each alphabet has a dept associated. For example letter "K" is a dept and the contact is example@gmail.com. The critical part is that all the letters are in a single cell. Need help...

Good morning guys I really need your help.. I tried to find a VBA for me but i didn't, and those i found i didn't understand at all! hahaha I would like a VBA to copy 4 specific things from na e-mail, there are: "CNPJ", "E-mail", "Phone" and "Name" (CNPJ and E-mail are the most important, and...

Hi! I have an Hyperlink concatenate for sending a mail by outlook. Now I want to activate the hyperlink automaticaly when a specific cell change ,so a mail will be send automatically when the cell change. Can you help me on this issue? Thanks Carina

Hi, I am currently working on a sheet, where I wish to achieve the following: Whenever one or multiple items with status (Column E) In Progress and Awaiting info (ONLY!), has been in the sheet for exactly 7 or 14 days, I receive an e-mail notification which lists the items in the e-mail body...

i have this code: Public Sub pdfopslag() Dim myCell As Range Dim valRules As Range path = Range("I21").Text Set valRules = Evaluate(Range("A9").Validation.Formula1) Application.ScreenUpdating = True...

Is there a macro that can scan over the context of an e-mail attachment on arrival and delete / move it to a certain folder if it contains it? in a previous thread, i mentioned i receive about 200 emails a day with Text files attached (nothing in the body of the e-mail, only the attached text...

Hello, I'm looking to save myself quite a bit of work. on avg, i'm receiving about 200 emails a day with automated .txt file attachments. the .txt files have information that i need from an automated source. all i have to do is look at 2 lines of the .txt e-mail and know exactly what needs to...

I have a list of e-mail addresses in column D. Column B populates from a query as mileage reports are received from employees. Until a report is received and captured by the query, the cell shows "#N/A" (A VLookup with no result yet.) I would like to send a single e-mail reminder to all...

Good morning all, been a while since I have been on here so hope everyone is well. I am a bit rusty and trying to put together a spreadsheet to show reminders for Gas Servicing. Most of it is pretty straightforward in that it would be Type Address Account Contact Phone E-Mail Date Due I would...