Royal Mail

[duder93]

Hi first post so bear with me,

I have an amazon small business - no more than 10 orders/day at best. I have a spreadsheet into which I import order reports and use VBA macros regularly to make life easy for myself. One time consuming task is typing the addresses of customers into Royal mail's online form to get postage from my pre-pay account.

I was wondering if there was a way of automating this, I have all the addresses in my spreadsheet.

Thanks!

 

[capparfrank]

Automating a web page is a very tailored process that can be quite frustrating if you don't have a strong understanding of how web forms work. It is also very vulnerable to breaking as the design of the web page is totally out of your control. Subtle changes can cause your automation to fail outright (hopefully) or to produce bizarre behaviors and possibly quite unpleasant results.

It's probably better for you to use excel to produce the addresses in a format that is extremely convenient for cut & paste into the web form. With a maximum of 10 entries per day, this might be a chore but isn't a terrible amount of work, I think.

However, if you really want to automate then you may want to to contact Royal mail directly and ask what their options are for bulk mailings/addressing. They may already have a system already in place that will be easier to interface with.

 

[duder93]

OK thanks a lot. I've emailed royal mail, but they say it can take up to 21 days for a reply!