vbcrlf

Please help me out how can i refer cell address in below VBA code to save file in desired destination in any folder. Option Explicit Sub create_and_email_pdf() ' Author - Philip Treacy :: http://www.linkedin.com/in/philiptreacy '...

I am attempting to automate an Outlook email creation from within Excel. I'm using Outlook 2016 and Excel 2016. I have a spreadsheet that the end user adds rows to, and flags the row to be emailed with a Yes/No value. I want the rows of data to be in a monospaced font, such as courier or...

Hi thread, Try to set up VBA to help me automate my remittance advice sending.. I want to loop through the rows in the table. But I am so new to the VBA, I need some help. Here is the code for my VBA. Sub Mail() Dim OutlookApp As Object Dim Mess As Object, Recip Dim Body As...

I am running an access query but when I get to this certain point, I error out. I am trying to import information from excel to access. It has worked in the past but the path broke and no longer works. Can you please assist as to why the error occurs. I bold the error below to show where it...

Hi all, below is current status of code as is, with the exception of a redacted email. It works just fine, however it saves the excel to the desktop as a PDF and attaches it to the email as a PDF Instead, I need it to save to desktop as PDF but still email as an excel document - can this be...

Hello, I hope someone can help me out, i have very little know-how in excel and VBA so i hope i can get some answers regarding a problem i have. I have this (read only) excel sheet for ordering parts and such, after selecting all the parts it makes a collection sheet ready to send thru mail...

Hi I have the following macro that works fine to send the active workbook to one recipient and one CC, with reference to two cells: Sub Mail_Workbook() 'Excel VBA to send mail. Dim OutApp As Object Dim OutMail As Object Dim str1 As String Dim str2 As String Dim str3 As String Dim str4...

Good Morning all I have the following code which I use at work to get folk to send me pdf files of certain reports from a excel workbook and its working fine. I am now TRYING to adopt this code in another workbook for use in sending a single worksheet (not as pdf) to another department by all...

Hello folks, I am hoping someone might be able to help out with some VBA code. I have the following code, which works fine for the first row. After it has completed that row I want it to move to next row until the cells are blank. I think I need to set the range as an integer, but I am not...

Hi Everybody, I wanted send the sheet I am on as a PDF and also I want to always add the second sheet in the workbook as a second PDF. I am using this code, but it only works for the current sheet: Sub PDF() Dim xSht As Worksheet Dim xFileDlg As FileDialog Dim xFolder As String Dim xYesorNo...

Hi Everybody, I'm using this code to create a PDF file for outlook. I wanted to always add the second sheet in the workbook as a second PDF. Can somebody please help me with that, really appreciate it. Thanks! Sub PDF() Dim xSht As Worksheet Dim xFileDlg As FileDialog Dim xFolder As String...

Dear All, I used office 32-bit but our PC changed to 64-bit. I need your help and code is below. If you put additional code, it will be good. I appreciate your help in advance. <colgroup><col></colgroup><tbody> Private Declare Function ShellExecute Lib "shell32.dll" _ Alias "ShellExecuteA"...

I found this code online which works very well apart from the fact that it only saves and e-mails the first sheet of my work book. Can someone help me set the specific sheets I want to e-mail if they are named: "Weld","Composite","Rubber"? Sub Saveaspdfandsend() Dim xSht As Worksheet Dim...

Hello: I am doing a macro to be able to send info of a table to ask for a project status Sub Button2_Click() ' Select the range of cells on the active worksheet. Dim Copyrange1 As String Dim Copyrange2 As String NU = Range("A2").Value Let Copyrange1 = "K" & 5 &...

I have posted the following in this forum in the link given below. Since, SOLVED is mentioned in the caption, I am not getting any reply from Experts. hence I amposting my two queries again here. Please reply...

Hi, I have created VBA code in Excel that takes the contents of a recordset and places the data (Date and Area) in the body of an email message. My code looks like this: This code all works great. The problem is that I want to output additional fields ( Date)and Area), and I want the data to...

Hello everybody, I am pretty new to this :smile: I found this code online, and it works pretty well but I would like to specify the saving path that is shows to the desktop. Is there a way? <code class="vb keyword" style="margin: 0px !important; padding: 0px !important; font-style: inherit...

Hello everybody, I am pretty new to this :) I found this code online, and it works pretty well but I would like to specify the saving path to the desktop. Could you guys help me please, thx a lot! <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family...

Been Looking around a way to avoid using HTMLbody as at work we have different signatures with different images and disclaimers. Everyone has their own signature set up using outlooks default tool. Is there anyway I can get the users own default signature added to this code in outlook without...

I'm subpar at VB, truthfully bit hopeless. So below is a code i found online. Ive tried to change it to meet my needs but its just guess work and trial and error so ive kept the below code that at least works. basically i need the code to do the following: Save current sheet as a PDF Save...