Import addresses into word from access?

Mark M · 4 Mar 2008 at 12:22

I have a database with various addresses. Is there a way to import a certain one into word by a drop down box or something?

Thanks, Mark

chronicbint · 4 Mar 2008 at 12:24

Can do a mail merge from Access if my memory is correct. Could probably automate it easily enough via VBA to word. But I have not worked with Access for years, didnt realise people still used it.

Mark M · 4 Mar 2008 at 12:28

o...k.... Its a database that comes with our tax software that lists all the tax offices. What would you recommend to use then instead of outlook? The file type is MDB

uv · 4 Mar 2008 at 12:43

export table contents into excel, mailmerge into word?

Mark M · 4 Mar 2008 at 12:45

Im not sure if its a mail merge that I want is it? We could be writing to any tax office and just wanted to be able to select the relevant tax office and click insert and in goes the address?

chronicbint · 5 Mar 2008 at 10:53

Its totally doable with Visual Basic for Applications(VBA). Google will provide plenty of answers.

But to be honest the easiest way would be to cut and paste