Microsoft Excel Help

galwayfreak

i have to send a few emails in work the emails go to the same people and the majority of the text is the same in every email. i only change a few numbers ie. dates, prices .......

i was researching hyperlinks today and i learned that u can add a subject to every email , that in its self will save me over half hour of work as i can't copy and paste as i have the larger body of text already to go for the ctrl +v

is there a way i can click on the email in excel as i use formulas to figure out the right number to put in the emails that it pops up the email window with the address and subject and a template text that i only need to edit the numbers

hopefully you can help me

galwayfreak

maybe this is in the wrong thread i just couldnt find where to put it .

Abelloid

Inserting a 'mailto' hyperlink in the worksheet will work, but you'll still need to paste the numbers in...not sure if this is what you mean..

[URL="mailto:person@email.com?subject=Enter your subject here&body=This is the body text"]Mailto[/URL]

galwayfreak

oh ya i have the mailto link done so that when i click it, it automaticly open a new email window with my subject. i just wondering if you can do a template that will be in the body of the text when i open it

seamus

What it sounds like you're looking for is a mail merge.

You have a spreadsheet full of data and a standard email template. The mail merge is a software functionality that literally merges the two things - the data from the spreadsheet is inserted into the required places in the template and then it's sent out - the email appears unique to each recipient.

It's normally used for creating tonnes of printed documents, but MS Outlook will do email Mail Merges.

galwayfreak

seamus that sound perfect . it really does except i dont know how to do an email template . do you know any site that will show me how to do it

seamus

http://www.google.ie/search?q=How+to+do+a+mail+merge+in+Outlook

I'm not being funny, just don't know which one of them will work best for you.

galwayfreak

seamus u are a star thats perfect . thanks very much