Mail Mergers ???????????
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 !
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 !
0
Comments
-
Yes there is.
Tools, Letters and mailings, Mail Merge Wizard..
:001_smile:0 -
how will word know what to import ????????????0
-
the mail merge wizard will take you through all the steps needed, selecting where the data is, where it is to be put etc0
-
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" ?0 -
0
-
For anything Office based: office.microsoft.com
Use mail merge for mass mailings and more:
http://office.microsoft.com/training/training.aspx?AssetID=RC0112056710330 -
What is this forum turning into? Are we offering secretarial assistance now?! Get a grip people, this is an accounts forum!0
-
:confused1:0
-
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
Dean0 -
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!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 583 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership