Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Microsoft Excel Help

  • 21-09-2010 10:44pm
    #1
    galwayfreak
    Registered Users Posts: 105 ✭✭


    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


Comments

  • #2
    galwayfreak
    Registered Users Posts: 105 ✭✭galwayfreak


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


  • #3
    Abelloid
    Registered Users, Registered Users 2 Posts: 3,495 ✭✭✭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]


  • #4
    galwayfreak
    Registered Users Posts: 105 ✭✭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


  • #5
    seamus
    Registered Users, Registered Users 2 Posts: 68,317 ✭✭✭✭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.


  • #6
    galwayfreak
    Registered Users Posts: 105 ✭✭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


  • Advertisement
  • #7
    seamus
    Registered Users, Registered Users 2 Posts: 68,317 ✭✭✭✭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.


  • #8
    galwayfreak
    Registered Users Posts: 105 ✭✭galwayfreak


    seamus u are a star thats perfect . thanks very much


Advertisement