Save as cell reference then email

Hello all

I am having trouble building a macro to Save As named by a reference
to a cell then email it to a predefined email address.

Does anyone have any VB code to make it happen?
Ms Excel 2007
5/19/2010 8:12:12 PM
excel.programming 6508 articles. 2 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 54

hi Josef,

You may some suitable code on one of Ron DeBruin's pages or on one of
the links:
'Example Code for sending mail from Excel'
'Links on the Internet about mailing'



Rob Brockett. Always learning & the best way to learn is to
broro183's Profile:
View this thread:

5/19/2010 9:34:52 PM

Similar Artilces:

When I am in one cell highlight another
Hello, When I am in one cell highlight another. Lets say that if my cursor is in A1 I want D1 highlighted or with another cursor on it. Then if I move to A2, D2 should be the one with another cursor or highlighted. Thank you for your help, Jose Juan Diaz hi, Jose Juan ! > When I am in one cell highlight another > ... if my cursor is in A1... D1 highlighted or with another cursor on it. > ... if I move to A2, D2 should be the one with another cursor or highlighted. 'put' a cursor on non-active-cell... [I don't think it's possible] :( to highlight 'D' wh...

Cells print so small I cannot read numbers. How do I fix?
I have been working with page break. Now I have the grid on 1 page..but it is far to small to read. now when I try to spread it back to 2 pages, it just takes the same tiny microscopic type and spreads it into 2 pages. I am stuck printing tiny type. How can I get the grid cells back to a size that is readable. It sound like you have selected Fit to 1 page in File > Page setup > Page > Scaling. Either select to fit it to 2 pages or select Adjust to 100% size -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Repl...

Why does copy and paste between eMails not work?
Copy no longer copies to the clipboard. Is there a setting I have deleted somewhere? Using Windows 7 and Office 2007 proffessional. Does it work if you restart outlook? Do you have any addins installed that could be erasing the clipboard? I've seen this happen with addins and contacts, but not email. to test, open the new message form before copying so you just need to copy and switch to the other message. ( -- Diane Poremsky [MVP - Outlook] Outlook Tips: Outlook & Exchange Solutions Cent...

Not able to send email from CRM client
Help, please. I cannot get CRM configured to send email from the CRM client software. See error message below. I have tried all the solutions I can find, including: -Confirmed mailserverurl is set correctly on the CRM server and that the specified server is the Exchange server. -Confirmed that the mailserverurl returns well formed XML. -Gave the IUSR_ORCAS user full control of the the "...mailroot/vsi 1" on the exchange box, which is named ORCAS. -Confirmed platformurl setting on Exchange server is correct. -Confirmed that the machines can communicate with each other. What...

Process all cells in a (user) selection
I am using this code to give me cell by cell access to a code defined selection; Dim aCell As Range For Each aCell In Sheet4.Range("A4:A34") ' Do Stuff Here Next aCell which processes every cell in the A4:A34 Range How do I do the same thing for a selection drawn by the user before pressing my 'Process' button ? Thanks On 05 May 2010 11:10:21 GMT, Isis <> wrote: >I am using this code to give me cell by cell access to a code defined >selection; > >Dim aCell As Range >For Each aCell In S...

ALL of my email is gone- getting error message as well
I am getting this message: The message store has been corrupted by an application external to Windows Mail. Windows Mail has been able to successfully recover from this corruption. (0x0000000) In addition ALL of my emails are gone. Any suggestions on how I can recover them? And what I should do about the message. Try running the various repair functions in the WMUtil program: If still no improvement, upgrade to Windows Live Mail: It will automatically import all your WM data. Gary VanderMolen, Microsoft MVP (Mai...

Sending email from exchange server to Win2k server on same domain
This has been bugging me, I have a win2K box with smtp installed, I want to allow users to send messages from exchange to the win2k server where they will be processed by some scripts. I have never tried this before and I am not sure of: 1. what is the address of the server ( 2. how should the exchange account/address be configured Any advice gratefully received Thanks Mark Mark Davey wrote: > This has been bugging me, I have a win2K box with smtp installed, I want to > allow users to send messages from exchange to the win2k server where they > will be proc...

think cell program
is anyone familiar with a program called think cell? Any thoughts? (powerpoint v 2003). Is this an add-in? thanks Sara It's very good. You can "try for free" from their website: Recent interview with one of the founders on Indezine: -- Echo [MS PPT MVP] What's new in PPT 2010? Fixing PowerPoint Annoyances PowerPoint 2007 Complete Makeover Kit

Incoming Emails
Hello, We installed the CRM1.2 on the same server with exchange. Everything is working fine except that the CRM users can not see incoming emails inside CRM although these emails are CRM emails. Can anybody tell what is the reason of that? Regards, Khalid Do you have installed the Router? The Router is a bridge=20 between the Exchange and the CRM who study the incoming=20 flow of emails and copy to the CRM everything who is of=20 the CRM. I hope who that help you.=20 []'s Vin=EDcius Pitta Lima de Ara=FAjo >-----Original Message----- >Hello, > We installed the CRM1.2 o...

No email stationery when through code
Hi I am creating email via code from access using below; Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) objOutlookMsg.To = "" objOutlookMsg.Subject = "Email Subject" objOutlookMsg.Body = "Dear abc..." objOutlookMsg.Display The problem is that the default signature that is set in outlook doe snot come up in the email. How can I fix it? Thanks Regards Am Sun, 17 Sep 2006 21:11:45 +0100 schri...

viewing LN emails (.nsf files) saved to CD in outlook?
I have lotus notes messages saved on CD, these are saved as .nsf files. Is there any way I can view these in Outlook? have tried various LN websites - to no avail. ...

no content in the email body
Haven't changed anything knowingly, but now when I receive emails all the content is in a .txt attachment which I open and goes to notepad. There is no content in the email body. "stephen" <> wrote in message news:<#TKSQf$oDHA.2776@tk2msftngp13.phx.gbl>... > Haven't changed anything knowingly, but now when I receive emails all the > content is > in a .txt attachment which I open and goes to notepad. > > There is no content in the email body. I've seen this before with an Outlook 2000 client. Couldn't find a way to fix it,...

Can you delete and empty an open email
Hi there Can you delete and empty an open email? I know I can delete and empty a closed email by holding down shift and then deleting, but have not been able to figure out how to delete and empty from an open email. Is this even possible? Thanks for your help. Kylie On Wed, 18 May 2005 20:01:03 -1000, Kylie B"" <> wrote: > Hi there > > Can you delete and empty an open email? I know I can delete and empty a > closed email by holding down shift and then deleting, but have not been > able > to figure out how to delet...

Newbie Cell Reference Question...
Hello, I apologize if this question has been answered before, but I'm no quite sure what to search for as I'm not very good with excel. I'm making a spreadsheet where one sheet references another. I'll tr to explain this as best as possible.... I'm creating a spreadsheet for a fantasy basketball league. I have "Data" sheet that contains data for all players. I have another sheet "Teams" that has all the players on each team. Column B contains th players name, and column C contains a number that corresponds to th row this player is on in the dat...

Moving Email Domain off of Exchange #2
Good afternoon, I am in the process of moving one of our clients off of our Exchange server and on to a third party email host. I have removed there domain from the default recepient policy, and also disabled and unattached or deleted their mailboxes. I have repointed there MX record to point to the new host etc. The problem is when I try to email them from our network my exchange server still thinks it is responsible for handling the mail for the domain and does not try to send it out of the domain. I get a 5.1.1 e-mail account does not exist in this organization. How do I let Exchange ...

Recovery after "do not save changes" selected accidently
I mistakenly clicked on "do not save changes" for a worksheet (file) that i'd been working on (I thought a different file was highlighted). As it turns out I had not saved the original file in over a day, though the autosave is set up. is there any way to get my file back, or at least an intermediate version, instead of one with a day's less of work??? help!!!!!! Thanks very much for your help! Sorry to say, but your day's work is gone. -- Greeting from the Gulf Coast! "Mayukh" <> wrote in...

I m receiving my email but after received it is not in my inbox
When I open the outlook and click on send/receive, I receive all the emails, but I could not find the downloaded email anywhere. It's not in my inbox or any of the folders that I have created. The unread mail also does not change to reflect that new emails have arrived. Could some one help me out here. Thanking you in advance. If you check your whole folder tree (composed of multiple PSTs possibly), are any folders showing as bold? "INAVAB" <> wrote in message > When I open...

Need Hyperlink from Menu Page to work in email
I have a workbook with several tabs. First tab is a "menu" type page (summary of other pages). Currently I have hyperlinks to all the other pages from the menu page. What I want to be able to do is copy the menu page into an email and enable the users to click on the existing hyperlinks (whatever adjustments needed) to go directly to their page of the workbook. Using Excel 2007. Please advise how to do this and what changes may be need for both options to work. ...

Contacts vs Personal Address Book. Can't pull emails into TO fiel
Howdy, I'm using Outlook 2k3 and having a slight problem. WHen I view my Contact list in the main view, I have two sets (not sure why but I'll be combining them). These lists have standard name, email, etc. Problem is when I go to create a new email message and click the TO: button, it tries to look for my Personal Address Book which I don't have. How can I make it not use the PAB and use the Contacts list instead? Thanks. OK, I think I just stumbled on the issue. For some reason on my COntacts Properties, the check box to tell Outlook to use that in the Address Book ...

Receive triplicate emails
On earthlink webmail, I only receive one of each email. When I "Send/Receive" from Outlook 2000, the Send/Receive window tells me I'm receiving 10 emails, but 30 appear in my inbox. Everything arrives in triplicate or duplicate. Extended headers appear to be the same in all three identical emails. Things I've tried and know: Deleted and then reconfigured my earthlink account many times. There is only one earthlink account. "Leave a copy of messages on server" is unchecked. Turned Earhlink Spamblocker On then Off then On then Off... no change. Sent test m...

Authenticating addresses for sending emails
I installed Office XP for Small Business on my laptop recently. Now, quite often I am getting an error message when I try to send an email to someone that says, "You must first authenticate this email address". Does anyone know how this is done? Thanks, Ken I have Office 2003 and I saw this once in my copy, I found it all I had to do was to add the person to my address book as it was part of the built in Spam filters. -- Tedd Riggs PDA Square Content Developer "Ken" <> wrote in message news:01fc01c3d94f$...

Email retention policy relative to CRM e-mails tracked from Outloo
Toss up question for the blue team. When one hits "Track in CRM" on an e-mail from outlook we all know that it CREATES an e-mail in the CRM system. The date that the e-mail is created in CRM is placed in the field CreatonDate. When we look at the related record it shows up in order based on the Created Date. The rub is this. What do we do when we have a user who is just coming on board with CRM and they have e-mail history they want to link that goes back years. There does not seem to be any linking relative to the received date. Which is actually much more relevant ...

Cell background shading in Excel
Why is it that the background shading colors available under the Paintbucket Icon chjange from file to file? Also, how can I add some of the colors to the paintbucket that are availabe under the format/cells/pattern pulldown? Colors are a Workbook-level property, so you can change the color palette for any workbook. Choose Tools/Options/Colors... and modify the colors to your hearts' content. You can also import another workbook's color palette from that dialog. Note however, that there are only 56 bins in the color palette, so you can only use 56 colors at a time. The paint b...

How do I send to myself at an alternate email address?
I have Outlook 2007 and am a new user. I have two separate email addresses - one thru a LAN at the office and one with a different provider. Outlook will not let me send to myself from one to the other. I seem to have no problem sending internally thru the LAN. Do you get any errors? If yes, please post the exact error message. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. ALWAYS post your Outlook version. How to ask a question: After furious head scratching, DeeJay asked: | I have Outlook 2007 an...

Sum every other cell?
I own a used-book shop. I have an Excel SS to track how many books pe day I sell in each of 28 categories and the $$$ I take in for eac category. So there's two columns for each day: #books & $$$. therefore want to add every odd-numbered cell in a row to get the tota number of books for a category in a given period of days and ever even-numbered cell in the same row for the the total $$$. Is there simple formula or function for this -- bookmanj ----------------------------------------------------------------------- bookmanjb's Profile: