vbnewline

Hi Experts, I need help on modified a VBA code below Sub Mail_small_Text_Outlook() Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0) xMailBody = "Dear All" &...

Hi All. I am currently trying to use a macro to pdf each individual sheet to email addresses in B2 of each sheet. This works perfectly. However I want to email using a different email account to my default one. This doesn't work perfectly! I have two seperate VBA scripts, one for PDF and...

I was recently upgraded to Windows 10. When I run my macro in Excel (2016 MSO 64-bit) that is supposed to create an outlook email and attach files from a specific folder, only some of the emails generate now. If both of the Excel files noted in the code don't exist in the folder, Outlook no...

With the help of this Forum I managed to build an Inputbox code that enables me to input golf scores for each player in turn. With a blank score entered if the player didn’t play. See code below. If possible, I am now wanting to use a UseForm to do the same thing. On the worksheet, each...

Hello, I'm not sure how to accurately provide a summary of what I'm trying to accomplish. I'm trying to create a user form that builds a "text template" based off of what a user inputs into the form. In short, the excel sheet would read: "Testing One Two Three" & vbnewline & vbnewline & "Did...

Hi everyone, I'm at a bit of a loss with this one as the code I'm using I've used before without issue. My goal is to have Excel move a worksheet to a new workbook, save that file and send it and then kill the file. All the code is working apart from the code to send an email, when I've took...

Hi, Using Excel 2016, I have a yearly workbook that is broken in to months, quarters, and year-to-date worksheets. At the start of each fiscal year (April to March), I want to give the user the ability to clear all of their data entries in the entire workbook at the click of a single...

I run a code that extracts some text from a database. I have two problems. 1. the line break character displays as a Carriage Return symbol rather than a line break. 2. [SOLVED]<solved<solved>The actual information displayed is always one step behind. By this I mean, I run it for part A it...

Hi! I have in the past emailed subtotaled sections in email but whey were exported into workbooks to a specified folder to be attached to an email. I am wanting to add them to the body of the email. They will all be going to 1 email address (for tracking purposes), to then be forwarded to...

Hi, I'm new to VBA. I wrote a code to send an email if there is a cell value change in column F, and the code works great. But I want to make sure the workbook is saved prior to sending out the email. The email text body must include the reference cell value, which is the value from column A of...

Hello, With some help from a fellow forum user i have this code: 1) The issues are i want it to save the file name as "x" which is tomorrows date and save it in a network shared folder. 2) i also want to include a image for my company logo after my position. in the body of the email which i...

Good day, I am currently trying to validate data using the user form. What I am trying to accomplish is to make mandatory fields filled before the user is able to submit the entered data. I am trying to use something like IsNumeric to validate, but can't find something similar regarding...

Hi Friends, I have build a code to select the filtered data to copy and paste into another worksheet. However there is an issue with it. When there is only one entry found from filtered data, it throws an error coz it selects the data till last row of the sheet. Kindly help me to correct the...

Hey everyone! I would like my code (pasted below) to not only count all instances of variable "myValue", but to also count instances of myValue which is generated with formulas. As is, it will only count cells where myValue actually is the value rather than also counting cells where myValue is...

hello , i use the following email template :- Option Explicit Sub PC_Email() Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim MailAttachments As String Dim cell As Variant ' Not previously DIM'd...

Hi all, I'm new to the world of VBA so forgive me if this is the wrong place to post. I've got a button within an Excel sheet that basically generates an email with some text in the body and the contents of the clipboard (this is always from using the snipping tool). I just can't seem to get...

i have a list of files in column d that i would like to move as per col e however nothing is copying over......can someone please help?

Hi, Looking to have a button within a spreadsheet that creates an email using outlook. Rather than just saying "Hello", I'd like it to say good morning up until 12:00, good afternoon until 17:00 and good evening. I'd also like to insert a signature at the bottom. Here's what I have so far...

Hi there I have the below code which works perfectly however I want to only export/save page 1 of the PDF not page 2. Can anyone please tell me how I can incorporate this in to the below code?: Sub emailsavePDF_weekly() Dim objOutlook As Object Dim objMail As Object Dim signature As...

Hi there I have the below code which I know is incorrect for the To. but I don't know how to fix? would appreciate any help. I have the list on another sheet. It's in a table if that helps: Table16[Email] Sub emailsavePDF_weekly() Dim objOutlook As Object Dim objMail As Object...