How do you set up a submit button to attach worksheet in email?

I am doing a form and I want to have a submit or send link on the bottom of 
the page. I know how to make hyperlinks but I dont know how to get it where 
when the user hits the send button it automatically saves that info and sends 
that form to the intended email address. Basically so you dont have to attach 
it yourself through email. Is there a way to do this? 
0
9/28/2005 5:39:04 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
469 Views

Similar Articles

[PageSpeed] 55

Have a look here for code to send mail

http://www.rondebruin.nl/sendmail.htm#Tips
-- 
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"almostthere002@yahoo.com" 
<almostthere002@yahoo.com@discussions.microsoft.com> wrote in message 
news:16BCDACA-6494-46AF-9408-46A2EFAD9F7A@microsoft.com...
>I am doing a form and I want to have a submit or send link on the bottom of
> the page. I know how to make hyperlinks but I dont know how to get it 
> where
> when the user hits the send button it automatically saves that info and 
> sends
> that form to the intended email address. Basically so you dont have to 
> attach
> it yourself through email. Is there a way to do this? 


0
9/28/2005 5:43:44 PM
Reply:

Similar Artilces:

Email Addresses not populating after creating new user
We are running SBS2003. After creating several new users, it is not populating the Email Addresses tab under the users properties. I have the checkbox for "Automatically update e-mail addresses based on recipient policy" checked and I have also tried to force apply the global recipient rules in Exchange Manager, but none of that is working. I think this is also the reason why Outlook is not able to resolve this users name when I try to connect their Outlook to the exchange server. Brian The problem could be that the Recipient Update Service cannot update the users becau...

Exchange 2003 Adding a footer to outgoing emails
Hello All, Anyone know of a way to add a footer to all outbound emails in Exchange 2003 Thanks Mark Hi Mark You can do it via an Event Sink as detailed in these articles: http://support.microsoft.com/default.aspx?scid=kb;en-us;317327 http://support.microsoft.com/default.aspx?scid=kb;en-us;317680 Or use a third-party app. -- Mark Fugatt Microsoft Limited This posting is provided "AS IS" with no warranties, and confers no rights. "Mark S." <mslater_nospam@m-e-c.com> wrote in message news:%23QMqSEnSFHA.3492@TK2MSFTNGP15.phx.gbl... > Hello All, &g...

Comments will not delete from Worksheet
Hi First post - be gentle! I am unable to delete Comments from one of my worksheets. When I try the machine just hangs (eggtimer) forever and the only way out is to Ctrl/Alt/Del. It only happens on this one worksheet - Comments on other Excel files delete OK. I have not knowingly "protected comments" on this one or anything similar. Any ideas as to what has happened? Thanks Grockle -- grockle ------------------------------------------------------------------------ grockle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26964 View this thread...

Outlook 2003 Navigation buttons fail
Hi there We have Outlook 2003 running on a PC. If you click on the navigation buttons, they all work except for the Contacts and Calendar ones! I click on Mail, and all displays normally. I then click on Contacts, and the left most pane (pain) changes to show the contacts heading and current views etc, but the main pane in the middle remains on mail! Tried everything to fix, including installing Office 2003 SP1. Any ideas? Thanks, Neal ...

Email Campaign with Attachments
Dear Community I've follwing problem, how can i attach e file to e email when i create a campaign (not a quick campaign!) over WEB an Outlook client ??? Can anyone give me a solution wich is usable for daily business ??? Thanx for all answers Marcel please save the campaign first, then you can attach the file. "Marcel" wrote: > Dear Community > > I've follwing problem, how can i attach e file to e email when i create a > campaign (not a quick campaign!) over WEB an Outlook client ??? > > Can anyone give me a solution wich is usable for daily busine...

Outlook 2003: Copy Full Names to email display Names
I recently upgraded to Outlook 2003 from 2000. I believe 2000 used to choose email addresses based on the Full Name field. 2003 appears to choose based on the Email Display name. Most of my email Display Names are just the email addresses. What is the easiest way to copy the Full Name to the email Display Name? What do you mean by "choose email addresses?" The Display Name has varied with each version of Outlook, but it is of no consequence. What makes you think it is? -- Russ Valentine [MVP-Outlook] "orbojeff" <jeff.callahan@orbograph.com> wrote in message new...

i set my rules and nothing happens
rules will not work i trouble shot and still nothing. I just want message from a contact to go in certan folder. please help. Princessholly <Princessholly@discussions.microsoft.com> wrote: > rules will not work i trouble shot and still nothing. I just want > message from a contact to go in certan folder. please help. State your Outlook version and the exact text of the rule that will not work. State if you have any other rules and, if so, where the failing rule is in the list in relation to the other rules. Give an example of a message you believe should trigger the rule b...

Master Worksheet reflecting sub-worksheets
This is, I realize, a database situation, but I have to work with Excel for certain reasons. Q?: How do I reference one worksheet to another? My example: I have three worksheets. "East", "West", "All"(master wksheet). They all have the same headers, which live in A$1:$V$2 I want worksheet All to contain the contents of East & West. As I update East/West, I would like All to reflect those changes. Rows may be added/deleted from East/West, so All would need to expand/contract appropriately. Using the information below the column headers, is there a way to...

Reply Button #3
Why can I not reply to a message. Everytime I click the reply button, Outlook freezes. Please help. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ...

Password Setting on Exchange
>I have outlook password protected, but I can only enter >the password once, and If I make a mistake, it locks me >out on exchange. Is there a setting within outlook that >let's me try to increase the number of tries for example >give 3 try before locking the user out. I do use NT security to logoin to my machine, but still want the extra security of protecting the outlook. I know there is a setting on exchange that can be used to do this, but I do not know what and where I can set it up. Any help is appreciated. ...

Links between different worksheets
I have a workbook with several worksheets in it. In one cell on the first worksheet, I am pulling information from another worksheet. The worksheet where this information is coming from is blank at the time so it is reporting a zero in the cell on the first worksheet. Rather than displaying a zero, I would like for it to be blank. I know in Access you can do this, but I don't know how to do it in Excel. I hope this makes sense. Any help would be appreciated. TIA, Mark Hi try something like =IF('sheet1'!A1="","",'sheet1'!A1) -- Regards Fra...

email problems
I am getting the following error message when I try to acces my email. Please advise. Thank you. An unknown error has occurred. Account: 'mail.bellsouth.net', Server: 'pop.att.yahoo.com', Protocol: POP3, Port: 995, Secure(SSL): Yes, Error Number: 0x80004005 In your browser go to http://mail.yahoo.com and log in to that account. Then clean out all the folders in your webmail. If you want to save any messages, create a new folder and move those messages to the new folder. Empty the spam and thrash folders also. Close webmail, then try Windows Mail again. Gary ...

Export email profiles
I have a client that is getting a new computer. I can move the pst file from one system to the other. However, this doesn't move the email address and settings. I understand that the settings are kept in the registry. Is there a way to export the email accounts and then import them on the new computer. In OE, we can export the email accounts and then reimport them on the new system. Is there a way to do this with Outlook 2003? Thanks, Joe Are the machines both running Outlook 2003? Will the user's .pst files be in the same location? If yes, to both, you should be able to use ...

Automatic Calculation on only one Worksheet
Is it possible to have one worksheet in a Workbook calulate manually while all others automatically? The reason I would like this is I have a sheet which pulls in real-time market data that slows down my Workbook if calculation is on automatic for the workbook. If I turn off automatic calculation for the workbook then I end up spending a lot of time hitting F9 or shift + F9. Thanks No. But I do think you can with two instances of Excel. Just start another Excel -- Kind regards, Niek Otten "sfrancoe2" <sfrancoe2@discussions.microsoft.com> wrote in message news:CF6DE...

multiple emails #3
Hey does anyone know why outlook is sending multiple emails to my distribution list? Please help it's really annoying my clients. See if the information on the following page helps: http://www.sperrysoftware.com/Outlook-Duplicates.asp -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- please reply only to the newsgroup to preserve the message thread. *** In news:052f01c3b25b$d0974b10$a401280a@phx.gbl, Jim wrote: > Hey does anyone know why outlook is sending multiple > emails to my distribution list? Please help it's really &...

setting up cash portion of account
One of my money accounts has a money market sweep account. How do I change money so that all cash transactions get posted to the seep account as opposed to the "cash" account. thanks much! gb1, Your investment account and your sweep account should not be two separate accounts in Money. All cash transactions in the single investment account are swept periodically (daily?) into the sweep investment (not an account). Treat the sweep investment like you would any other investment in the account. When choosing the type of investment from the investment wizard, choose money mark...

How to keep the print output colour setting for the same file?
I have two Excel files saved in a network drive. And I access the files in two different servers in a separate location. I have no problem printing both the files with the correct setting (especially the print output colour) that I saved with the files using one of the servers. However, when I try to print the same files in the other server; one of the files print setting has changed to black and white. These files are the same files that I opened in a same network drive. Wondering why one file print setting works and the other doesn't. Can anyone can help? ...

Country, Phone and email showing inthe Bill to or Ship To fields
When we set a customer in Store Operations POS we need to verify some extra information in the Bill to and Ship to windows for shipping purposes. Is there a way to display the Country, Phone number and the email address in these windows? At the very least we need to be able to see the country. Had a similar issue a few months ago where I needed to see customer email, phone, available balance, and account number - but the white boxes "bill to" and "ship to" aren't editable, so I got assistance on this newsgroup (think it was Jerry Data - thanks Jerry) on editing...

Html emails stripped down to plain text
I have two users for the company I work for that are trying to send html formatted emails to eachother they are using Outlook 2003. Now I know all the security issues and stuff that comes with it but they are the bosses and thats what they want. So when User A sends an email to User B the html is stripped out and its put into plain text. But when User B gets html emails from others they can see it in html. User A can recieve and read html emails from User B just fine. So my question is who has the problem User A or User B and what is the problem? Then how do you fix that problem? Thanks,...

Link 'Button' to Macro
I've created an ActiveX Button. How do I make clicking on this butto execute a macro -- Message posted from http://www.ExcelForum.com Make sure that you are in design mode and then double click on your button. This will take you into the VBA editor. You will see some code that looks like this: Private Sub CommandButton1_Click() End Sub Where CommandButton(1) is the name of your button. Now type in the name of your macro between the sub/end sub sections. Save your changes and close the editor. Close the design view and your button should work. Hope this helps Paul Falla >---...

Easily change smtp servers for all email-accounts
People, I got my laptop with me basically everywhere I go, but I find it totally annoying that I have to change the smtp-server settings for each and every account when wanting to send mail from a different location than the time before. I have about 15 accounts that I regularly recieve email to and ehwn I reply to these I always have to change the smtp-server. Is there a way to fix this easily for all accounts? Best regards, Henning Frettem Oslo, Norway I should probably mention that I run MS Office 2002 SP3 ...

Viewing picture attachments in outlook 2003
When I used to use outlook express and received an e-mail from someone that had attached a jpg or pic file.. it could be viewed by just scrolling down the message. I notice this isn't the way outlook 2003 handles the pic files.. but it was handy if someone sent a few in one e-mail.. Is there anyway to set this up instead of having to click on each individual pic attachment. no. outlook does not support inline image viewing. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Outlook Tips: http://www.outlook-tips.net/ http://www.poremsky.com - http://www...

Corrupt emails when using multipart content types
I am running Exchange 2003 with latest SPs and am running into a very strange problem. When we receive certain emails, the contents of the messages have been corrupted. Exclamation points (!) seem to appear randomly in the text (usually an exclamation point followed by a space). The messages both contain HTML and TEXT content, the header is: Content-Type: multipart/alternative; boundary="----=_NextPart_000_365D_01C59758.21CA9D10" The text version content type is: ------=_NextPart_000_365D_01C59758.21CA9D10 Content-Type: text/plain; charset="iso-8859-1" Content-Tr...

Can CRM send Email without exchange?
Hi all, I asked this question the other day, but I re-read my post and it made no sense! Hence no replies I guess. My questions (put a bit more eloqantly) are: 1) Do you HAVE to use exchange to fire out an email? Can it be handled through CRM? Surely it's just pushing out SMTP traffic, but knowing MS this answer is going to be "no you must have exchange" 2) Can CRM be configured to use mailbox enabled user accounts that dont have the upn of the domain that the crm machine is in. As far as I can see, if you add the user into CRM by it's pre 2K name ie domain\username it wi...

Sorting filtered list on form with a Command Button
I have a form CLIENTLIST. When I open this form it runs the query qryClientLst. One of the fields in the query named ClientID has the criteria "Like [Enter Client Number]". When I open the form CLIENTLIST I'm prompted to "Enter Client Number". When I do the form opens and only the files with the client number I entered appear. So basically it's a filtered form. All of this works fine. I created a command button above the column ClientId on my form so my users can click on the button and sort Ascending or Descending. Below is my code for this. My only...