Email Sheets To Various Contacts In PDF And Also Excel (but Locked)

May 13, 2014

Work on a spreadsheet with multiple sheets , that will then be emailed once a month, with different sheets going to different contacts because of our timezone difference.

If a sheet could be used to maintain a list of contacts and which sheet to email out Also in which format PDF, Excel (locked down) or both would be useful.

A button maybe on the contact sheet to start the process / but also with an option to set-up to email on a certain day per month would be good.

the number of contacts at the moment varies between 1 and 4 for each sheet - perhaps , we could set-up to email up to 10 contacts per sheet

The email client is Outlook

Each contact should only receive their sheet and not see any of the other sheets , also the contacts should not be able to alter the spreadsheet at all. hence the possibility of using PDF , but most still would like to see the report in excel format.

there would be about 20 sheets , to go to between 1 and 10 contacts for each sheet

I have attached a dummy workbook , which has 4 example worksheets in

In the real workbook, the worksheet names , also will have spaces in them.

I could setup a Start Sheet and a finish sheet - so that the macro - can go through each worksheet in between , if that offers a solution also a maintenance sheet which has the sheet name , email contacts email address and PDF, Excel or both format.

I have outlook on my PC , so i can play - BUT its not connected via exchange server, if that makes any difference.

View 2 Replies


ADVERTISEMENT

Any Way To Import Excel Contacts To Outlook?

May 17, 2013

Wanted to know can I transfer excel sheet to outlook pst?? If yes then how can I do so??? As I have lots of contacts list in Excel sheet but now I wanted to import those contacts to Outlook.

View 2 Replies View Related

Get Outlook Contacts For Organization Using Excel Macro Vba?

Mar 14, 2014

How to get the outlook contacts for the organization using excel macro vba.

View 14 Replies View Related

Excel Macro To Import Contacts And Place Them On Particular Sheet?

May 2, 2014

I have come up the code below. It imports contact information from Outlook contacts in a contact folder called Private Contacts. The below code has been copied and modified from this forum.

As it stands the macro creates a new workbook and places the data on that. What I need it to do is create a new worksheet with the name of private compare on the active workbook and then place the data on that worksheet.

[Code] .....

View 6 Replies View Related

Excel 2010 :: VBA Loop Code To Automatically Email Range Of Cells And Email Addresses

Sep 16, 2013

I am using Excel 2010. I have been given a task at work that can save my team a lot of time if I can solve the problem. Every month, we have a spreadsheet with about 5000 rows that we have to email. In each row, there is a range that we have to email to a specific email. For example, I would have to copy and paste Range A2-R2 in the body of the email, and then email it to whatever email is in cell S2. I would then continue this for the next 5000 lines, making it a possibility that i will be sending 5000 emails manually.

I have been trying to come up with a solution through VBA that would automatically send these emails. My goal is to automatically send the Range A2-R2 to outlook email, then cell S2 into the "To" email address box, and then automatically send it. So far, i have successfully been able to send one row, but cannot figure out how to loop it for the remainder of the rows.

A couple other key points are that I have column headings as well (Range A1-R1). If possible, I want to be able to include the column headings in the email body as well. Example - first email would be range A1-R2. second email would be range A1-R1 and A3-R3, and so forth. The body of the email would also contain a standard script, such as "Please review the information below."

The goal here is to save everyone from having to send 5000+ manual emails. This would be a big boost for my team.

Code:

Sub Email()
Dim rng As Range
Dim OutApp As Object

[Code].....

View 5 Replies View Related

Excel 2010 :: Get NEW Email On Basis Of Available Email

Apr 15, 2014

We know that professional emails have a fixed format. I have a list of people with their names and emails and there are some people for which emails are missing. I am pasting my sample data below. But first let me explain the meaning of columns.

Column A: Means full name of the person for which we have email id
Column B & C: just split of Available full name into first name and last name
Column D: Email id of the person with full name in column A
Column E: For the names in this column, we need to get email ids
Column H: Sample result

Now basis on the Full Name(Column A) and Email Id(Column D) can we get the email id for person in Column E.

Sheet4
A
B
C
D
E
F
G
H

1
Available Full Name
Available FirstName
Available LastName
Email for available full name
Actual Full name
Actual firstname
Actual lastname
Sample result

[Code] .........

View 2 Replies View Related

Excel 2010 :: File Is Locked For Editing?

Jun 29, 2014

I tried to open excel file from shared drive but it's pop up

"File in use" xxxx.xls is locked for editing by XXXX, Open 'Read-Only' or click 'Notify' to open read-only and receive notification when the document is no longer in use.

I din't know how to insert the picture so that I wrote everything.

It happens almost every time even if file has not opened by any one. how can I stop it? Version: Excel 2010. OS Name: Microsoft windows 7 professional.

View 4 Replies View Related

Excel 2010 :: Enable Sorting A-Z In Locked Workbook

Jun 19, 2014

I have a workbook with a tab for each day of the month. This workbook is placed in a shared file and used by various yards in different locations. A new yard beginning the process is refusing to use it because due to formulas we must lock the workbook (contains many formulas and a live clock macro to track trip time) and they cannot sort A-Z. The sheets are labeled 1,2,3,4,5,6,7,8,9 and so on to 31. I know that you can write a Macro to allow sorting, but I cannot get it to work. the users CANNOT know the password due to hidden revenue etc. and formulas.

View 6 Replies View Related

Email Selected Sheets Via Userform

Apr 3, 2014

I am trying to set up something similar to the old "print dialogue" box whereupon the user presses a command button on the userform and all sheets within the work book are listed (eg:sheet1, sheet2 etc) The user can select any amount of sheets and and using "OK" outlook is fired up- pretty similar to Ron de Bruins code for email.

I have tried taking the print dialogue vba and stooping it at copy, then trying to gets Ron's code to continue- without success.

There are great bits of code I've seen for select tabs and selct sheets from listbox, but I have found none to email once selected.

View 4 Replies View Related

VB Code To Email Separate Sheets

Jun 26, 2008

below is a VB code to email separate sheets based on sheet anme and email address on a sheet called " mail".

Code seems to fail at the last line " Next a" any ideas why this is not working

Sub Mail_sheets()
Dim MyArr As Variant
Dim last As Long
Dim shname As Long
Dim a As Integer
Dim Arr() As String
Dim N As Integer
Dim strdate As String
For a = 1 To 253 Step 3
If ThisWorkbook.Sheets("mail").Cells(1, a).Value = "" Then
Exit Sub

View 9 Replies View Related

Imported Contacts To Appear In Autocomplete?

Jun 17, 2013

Imported contacts to appear in Autocomplete?

View 1 Replies View Related

How To Check Duplicate Contacts

Aug 29, 2013

I have a workbook with a list of new contacts in one sheet, and a list of old contacts on another sheet.

I want to run a duplicate check throughout the workbook to highlight and delete any contacts on my new list, that have already been contacted on my old list.

Also, I need the the duplicate checker to check for non specific names, regardless of punctuation, upper/lower case, etc.

I need to to highlight all of the following variations as possible duplicates which i can then review & delete manually;

Apple Corp,
Apple Ltd
APPLE LTD
Apple.com
etc...

What I can use to do this?

View 3 Replies View Related

Merging Two Sets Of Contacts?

Oct 17, 2013

I am trying to merge my boss's contacts. He has one enormous set of contacts in GMail (5000+) and one enormous set of contacts in Excel (5000+) I've exported both sets into excel but how to I merge them?

The headers for each set are in a slightly different order (Home Address, Office Address, Email ...vs.....Office Address, Home Address, Email) Do I need to make sure the order of the headers match in both the GMail Sheet and the Outlook Sheet and is there a faster way to do that than just rearranging them manually?

My second question is how do I merge them? There are a lot of over-laps of people but some info might be different in Outlook than in GMail. For example I might have John Smith as a contact in both Gmail and Outlook but two different email addresses for him under the header "Email 1" how do I make sure one email doesn't eliminate the other? I just want to merge both sets of contact info for each person into one super contact.

View 4 Replies View Related

Tranpose Mulltiple Contacts From One Row

Apr 21, 2009

I would like to ask about How to Tranpose mulltiple contacts from one row.

Example:
Company1Firstname Lastname1 Firstname Lastname2 Firstname Lastname3Title1 Title2 Title3Company2Firstname Lastname1 Firstname Lastname2 Firstname Lastname3Title1 Title2 Title3
result need to be.

Company1Firstname1Lastname1Title1Company1Firstname2Lastname2Title2Company1Firstname3Lastname3Title3Company2Firstname1Lastname1Title1Company2Firstname2Lastname2Title2Company2Firstname3Lastname3Title3

View 9 Replies View Related

Number Of Unique Contacts

Sep 23, 2009

Client Id Contact No. Unique Contacts 111123 12 3 111123 12 3 221123 2 2 111123 34 3 111123 5 3 221123 1 2 821123 4 1 221123 2 2

I am trying to calculate the number of unique contacts that each client has made. So in the example above Client No. 111123 has made 3 unique contacts - numbers 12,34 and 5.

However I'm not having any luck - as I suspect it will be a fiendish array formulae. Alternatively I'd settle for some VBA.

View 9 Replies View Related

Contacts From Worksheet To Outlook

Jun 5, 2007

I have been trying to use VB to send contacts from contacts.xls to outlook. I have some code from MSDN that shows me how to put in ONE contact (which is already declared in the code). Well I was thinking of writing something to take a worksheet that has x number of contacts and automating x number of contacts. The problem is, I am familiar with using SQL to pull records, but I was thinking there was something easier like importing the excel namespace. So I decided to try it out this way and found this little tidbit of code which is:

Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
xlApp = New Excel.Application
xlApp.Visible = False
xlBook = xlApp.Workbooks.Open("contacts.xls")
xlSheet = xlBook.Worksheets(1)

'READ FILE HERE
Dim pXLRange As Object

pXLRange = xlSheet.UsedRange

Dim i = 0
Dim j = 0
For i = 1 To UBound(pXLRange, 1)
For j = 1 To UBound(pXLRange, 2)
Debug.Print(pXLRange(i, j))
Next
Next

It gives me this error for the FOR i=1 to UBound line:

Unable to cast COM object of type 'System.__ComObject' to class type 'System. Array'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.

here's the namespaces i have imported:

Imports Outlook = Microsoft.Office.Interop.Outlook
Imports System.Reflection
Imports System.Data.OleDb
Imports Excel = Microsoft.Office.Interop.Excel

View 5 Replies View Related

Dropdown Menu To Get Contacts In Sheet

Dec 20, 2012

i have a excel sheet which i use to estimate of course i have many contractors i use

my question is, is it possible to create a drop down menu with the contractors name and autofill the cells below with the address

Cell_B5 Company (Dropdown)
Cell_B6 111 Street Rd
Cell_B7 TownCity State 11111

or is it without a dropdown possible by just typing the first few letters and then autofill and how to do this

View 3 Replies View Related

Importing Phone Numbers And Contacts

May 15, 2007

How do i go about importing contacts - names, numbers, addresses that are in excel into Microsoft Outlook?

View 2 Replies View Related

Matching Last / First Name From Two Sheets - Adding Email Addresses To Third Column

Jun 4, 2014

Have two sheets, both very different, but each containing Last Name, First Name and a column for email addresses (one sheet has the email addresses entered, the other does not)

What we are trying to do is look for matches in Last/First columns between the two sheets and if/when found copy the email addresses from one sheet to the other.

Worksheet A: Last=B2 First=C2 Email Address=F2
Worksheet B: Last=A2 First=B2 Email Address=C2

View 5 Replies View Related

Merging Workbooks: So All The Information I Have About These Contacts Is In The Same Book

Jul 15, 2007

I have 2 books right now. Each book has 2 colums of data (See attached jpg.):

Book 1 has a column for "phone number" and another for "street"
Book 2 has a column for "phone number" and another for "house number"

I would like to merge these books together so that all the information I have about these contacts is in the same book. Column A will be the phone numbers, column B will be the street name, and column C will be the house number. As you can see by looking at book 2, I only have house numbers for some of the phone numbers in book 1. My goal here is to have book 2 "look at" book 1, and add any information book 1 does not have (such as house number) to the relevant row (the row where the phone numbers match). This new book will by my book 3. I've attached a jpg. with how book 1 looks, book 2 looks, and how I want book 3 to look.

View 2 Replies View Related

Generate Email From Excel?

Jun 18, 2014

I am looking for Excel to auto generate an email (to myself) when the following happens:

Basically, I have products with promotions which each have a start and end date. I have an excel sheet which we manually enter the promotions start and end dates into. I have a seperate column which has a basic formula to indicate the days remaining until the promotion comes to an end.

I would like excel to automatically send me an email to notify me when the promotion is due to end one week in advance.

So I will have a column which effectively shows the days remaining (number) until the promotion ends, when this number hits 7, I would like the email to be sent to myself stating (Model number XYZ. Promo ending soon).

View 1 Replies View Related

Auto Email From Excel

Mar 13, 2014

I have an excel sheet which contains Supplier certs issue date and date of expiry of a particular cert. I would like to send an email to user when the date of expiry is met. I have very little knowledge or no knowledge of coding in VB. I want to send the email 30 days before the cert expire. i have attached the file.

SupplierCertificatesForm.xlsx‎

View 1 Replies View Related

Email Worksheet From Excel

Oct 26, 2009

So I want to be able to send out a meial of a copy of a wrok sheet from Excel. I wan to be able to send out and orginal (Insert Referral) and then a modified version (out). I got the code working for the out version but when I copy the code and change the names it does not insert the email addresses in the TO: address bar in outlook. the VBA cose is pulling the email adress off of a worksheet depending on who I want each task to goto. I just can not figure out why my second code is not working. Here is the working first code

View 8 Replies View Related

Email Sending Through Excel?

Aug 30, 2013

editing the code below. what i want is when i filter column X, all email addresses appearing in column V will be included in the TO field in my mail.

Option Explicit
Sub SendEmail()
Dim OutApp As Object

[Code]....

View 1 Replies View Related

Sending Email Via VBA In Excel

Jan 23, 2014

I have written code in VBA to send emails via Excel based on a name that is held in a spreasheet that is then looked up against an organisation address book. What I need to know is there anyway that you can save mails into the Draft folder that were unable to send for example if they have an email adress that is incomplete or not recognised or if the email box has reached capacity?

With OutMail
.SentOnBehalfOfName = "XXX"
.To = Emails
'.CC = "XXX"
.BCC = ""
.Subject = pi.Name & " - Enablement Request"

[code]......

View 4 Replies View Related

VBA Code To Email From Excel

Mar 19, 2014

I am trying to find a vba code so that I can generate a email from excel that the MOT is due within 28 days. I am new to VBA.

View 3 Replies View Related

Excel 2010 :: How To Set To Email From Outlook

Jan 30, 2014

I run excel 2010 on a windows 8.1 machine. In excel I have email address that I need to mail from however when I click the hyperlink it automatically directs me to Hotmail. Is there a way to change that to automatically load Outlook instead?

View 7 Replies View Related

Bulk Email Addresses To Excel?

Apr 22, 2013

How do I copy 100 email addresses at the top of an email and post them in an Excell spreadsheet where each email address is in one cell i.e. 100 cells?

View 2 Replies View Related

Sending Email From Excel Via Web Outlook (OWA)

Jun 23, 2014

i have the following code in my Excel worksheet. This code successfully send out email to our customers when if the criteria is true. I have tested this at home and it works perfectly as I use Outlook at home. However when I take this code to work I couldn't get this working as at work we use Outlook 365 and we use web Outlook, OWA.

Is there a setting I can specify to use OWA as I don't think I am allowed to install outlook at work.

[Code] .....

View 5 Replies View Related

Excel VBA To Email Hyperlink From Textbox?

Aug 4, 2005

I have an excel spreadsheet on a network, and I need to be able to email a link to the spreadsheet to everyone who needs to use it.

I have done the formula =cell("filename") to get the filepath, i have created a userform which initialises textbox1 to pick up the filename. I have written a macros to create an email, it puts in the subject and the body of the message. In the body of the message is the value of textbox1, but i cannot get it to format this filepath as a hyperlink.

Here's the code in it's entirity i have done:

[VBA]
Private Sub CommandButton1_Click()
ESubject = "A Workbook has been created which requires your input."
SendTo = ""

[Code]....

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved