Royal Mail

duder93

New Member
Joined
Jun 13, 2011
Messages
3
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!
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

capparfrank

New Member
Joined
Feb 11, 2011
Messages
41
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

New Member
Joined
Jun 13, 2011
Messages
3
OK thanks a lot. I've emailed royal mail, but they say it can take up to 21 days for a reply!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,525
Messages
5,469,171
Members
406,641
Latest member
snyderman

This Week's Hot Topics

Top