PDA

View Full Version : Mail Mergers ???????????

jhill
06-03-08, 11:55
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 !
deanshepherd
06-03-08, 12:30
Yes there is.

Tools, Letters and mailings, Mail Merge Wizard..

:001_smile:
jhill
06-03-08, 13:11
how will word know what to import ????????????
richardw
06-03-08, 13:26
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
06-03-08, 16:31
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
06-03-08, 17:12
Take a look here (http://mistupid.com/technical/mailmerge/) for a step by step video guide.

Google is your friend and mine!
richardw
06-03-08, 21:23
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
07-03-08, 11:45
What is this forum turning into? Are we offering secretarial assistance now?! Get a grip people, this is an accounts forum!
deanshepherd
07-03-08, 11:56
:confused1:
Dean
07-03-08, 14:24
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
07-03-08, 15:05
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!