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 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

Excel Query

  • 25-01-2012 5:06pm
    #1
    donalg1
    Closed Accounts Posts: 3,513 ✭✭✭


    Hi need some help with an excel formula, basically I have one spreadsheet with say name address and everything which I plan to use for a mail merge to send standard letters, however I have to include a field with requirements which are standard requirements but will vary from one letter to the next so say I have a column called requirements and in this I want to insert say A1, B3, C4.

    Then on a seperate worksheet I have a list of requirements for instance A1: This must be amended as its dangerous

    B3: You must replace this immediately

    C4: This is ok but needs to be moved

    So in the requirements field on the first worksheet I put A1, B3, C4 this generates the full requirements on the word document when merged.

    Is there any way to merge this to a Word Document which will give appear like this.

    We wish to inform you that you are required to meet the following requirements A1, B3 and C4 which are as follows:

    A1: This must be amended as its dangerous

    B3: You must replace this immediately

    C4: This is ok but needs to be moved

    Please get in touch when the above works have been carried out.

    Hope this makes sense any help you could give would be appreciated.


Comments

Advertisement