Mail Mergers ???????????

Options
jhill
jhill Registered Posts: 23 New contributor 🐸
Hello All. Thsi is not directly accounts related but hoping you can help me ease my workload.

I have been given a letter template in word where the addrees space is left blank.

Then in excel a list of all the address'ss i need to send the letter to, Over 100

cell A1 Mr Smith
B1 22 hackeny road
C1 london
D1 NW1

surley there must be some sort of mail merger function that will import the address'ss automaticlly, at the moment i am typing them out 1 by one.

PLEASE HELP ME !!! THANKS !

Comments

  • deanshepherd
    deanshepherd Registered Posts: 1,809 Beyond epic contributor 🧙‍♂️
    Options
    Yes there is.

    Tools, Letters and mailings, Mail Merge Wizard..

    :001_smile:
  • jhill
    jhill Registered Posts: 23 New contributor 🐸
    Options
    how will word know what to import ????????????
  • richardw
    richardw Registered Posts: 108 Dedicated contributor 🦉
    Options
    the mail merge wizard will take you through all the steps needed, selecting where the data is, where it is to be put etc
  • jhill
    jhill Registered Posts: 23 New contributor 🐸
    Options
    ive tried it i must be really thick as i can not work it out.

    any chance of a step by step guide ?

    as ive mentioned at the moment its is simply the word letter template and the excel file with the address'ss, they are in no way linked and are just normal files.

    firstly do i select - "use an existing list" or "type a new list" ?
  • deanshepherd
    deanshepherd Registered Posts: 1,809 Beyond epic contributor 🧙‍♂️
    Options
    Take a look here for a step by step video guide.

    Google is your friend and mine!
  • richardw
    richardw Registered Posts: 108 Dedicated contributor 🦉
    Options
    For anything Office based: office.microsoft.com

    Use mail merge for mass mailings and more:
    http://office.microsoft.com/training/training.aspx?AssetID=RC011205671033
  • red_devil
    red_devil Registered Posts: 52 Regular contributor ⭐
    Options
    What is this forum turning into? Are we offering secretarial assistance now?! Get a grip people, this is an accounts forum!
  • deanshepherd
    deanshepherd Registered Posts: 1,809 Beyond epic contributor 🧙‍♂️
    Options
    :confused1:
  • Dean
    Dean Registered Posts: 646 Epic contributor 🐘
    Options
    Red devil, you obviously don't see this as 'practice management and development!' I suggest you contribute to the forums in a more positive manner or not at all!

    Regards

    Dean
  • red_devil
    red_devil Registered Posts: 52 Regular contributor ⭐
    Options
    Dean wrote: »
    Red devil, you obviously don't see this as 'practice management and development!' I suggest you contribute to the forums in a more positive manner or not at all!

    Regards

    Dean

    So sorry Dean. I hadn't realised that the principle of free speech wasn't applied on these forums. Cheer up man, what's the matter with you? It's Friday afternoon for goodness sake!
Privacy Policy