e-mail

Current process is selecting individuals manually to send e-mail. I'd like to use Access to somewhat automate the process to send static e-mail (except for date update) to different individuals. I have 4 tables set up: tblDate - contains calendar thru 12/31/2025 tblEmail - would contain...

Hi, Iv'e got a helper column which produces an e-mail address in the cell A1 using the formula: =VLOOKUP(E9,A2:BI430,6,FALSE) In another cell I have: =HYPERLINK(A1) It produces a linked cell with the correct email, but when I click it I get the message: "Cannot Open The Specified File". Can...

Good morning all, I am seeking some assistance with some VBA code that I have been using. The code when run attaches the workbook to an outlook e-mail and populates the addresses based on hyperlinks shown in the worksheet. It also populates the subject and body of the text of the e-mail. I...

Hi guys! :warning:ATTENTION NEWBIE IN ACTION:warning: So i recently started working with excel and VBA at work, and got hooked right away! However, now i'm standing in neck deep in spreadsheet(... get it?) and need some fresh eyes to point out my error. The goal is to have a macro that once...

Hello all, I have searched an answer for my question but couldn't find one. Please excuse me if there was a similar one. Right now my excel file can create PDF and send e-mails thanks to Ron de Bruin's add-in. What I do is, I change the value of one specific cell manually which updates the...

Hey all, frustrations have long since set in so I'm looking for a little help due to my limitations. The code below is set to automatically provide an e-mail once zTardy reaches a value that exceeds zTardyLimit. This is one of the steps that I need to get accomplished however I am really...

Good afternoon, I'm working on a Macro to email various POCs. Currently I've got one tab that I'm working off of, but ultimately I'd like to have multiple tabs and have the macro look for the data on each tab. Here's the code: Sub Email() Dim OutApp As Object Dim OutMail As Object...

Hi all, I am trying to create a tool using VBA that can send forecasts to suppliers. The message consists of an intro in cells A2:J11. Columns A:J will have the forecast which will be copied from another sheet (the number of row varies depending on supplier). And finally there is a note at the...

Hi, I am quite new to VBA programming within Office. So far I was able to solve a few issues myself with a friend, but my current issue is bugging my mind and would like to ask for your assistance. I have a report with pivots which shows me certain violations in my system. For those violations...

Hello, I am currently producing a spreadsheet which can be accessed my multiple users. I have included a button in which opens a VBA User form. I want the users to fill in the details and when they press send, the form comes to me in that form with a clear subject field and body field. Everyone...

I'm sorry for the length of the post, I am trying to provide as much info as possible. I have a shared workbook form that various users fill in and then send to the appropriate managers for approvals. The workbook is basically a template, although just saved as a normal .xls workbook (sadly...

Hi there, I was looking over the forum's and noticed that you where kind enough to help someone out with a Mail Merge Email with Attachments (</SPAN>VBA</SPAN>) Query and I was wondering if you might be able to provide me with some assistance. I have been on...

Hi, What is wrong with this code?Sub Send_via_email(Cancel As Boolean)'' Send_via_email Macro' Dim blnCancel As Boolean Dim sMail As String Dim rngCell1 As Excel.Range, rngCell2 As Excel.Range sMail = Application.Dialogs(xlDialogSendMail).Show blnCancel = Not...

Hi,I have a worksheet where I am comparing two columns of data and if they don't match then it does not allow the user to close the file. This is the code I have and it works well. However I also have a button which takes the user to an outlook message for them to e-mail the current worksheet...

I am writing vba code to create Outlook tasks for various employees from an Excel spreadsheet. The spreadsheet contains a list of reports under review and who is assigned to review the task. I want the vba code to create an Outlook task for the individual assigned to review the report. I...

I would like some pretty straight forward code to send an email with an attachment. I currently can use the ActiveWorkbook.SendMail code with an array for all my email address, but it does not allow you to CC anyone or the text you want for the body. I have tried several different suggestions...

Hey there, I created an Excel-based reporting system, which uses individual files in a shared folder. The users enter their updates in their files, and then use macros in the file to Request approval for their updates from their managers, and Release the approved data for consolidation. The...

I have several macros in a workbook to send e-mails to different address groups depending on specific scenarios. The e-mail body text will always be the same. What I want to do is have the body text written in just one single location and not in every macro so that when someone wants to change...

Working in Excel 2010 I have a workbook I'll call Group 1. There are 11 available worksheets, and anywhere from 1-11 of these sheets are assigned to a different company name. The worksheets themselves are simply numbered 1-11, the company names are always referenced in cell D3. I am not going to...

Hello all, I have a spreadsheet that has a list of products that I need to order and dates that they need to be ordered by. I would like to set up e-mail notifications when the date required to order is 10 days away. From my research it looks like I need to write some code to accomplish...